{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-05-19","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":14,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1219,1103","block_room_bookings":[{"confirmation_number":"BV12245084272","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","bundle_room":"0"},{"confirmation_number":"PB12260697091","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3094851","reservation_id":"94924","confirmation_number":"PB12319593837","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"125.37,125.37","nightly_discount":"0,0","subtotal":"250.74","grand_total":"283.33","paid_amount":"283.33","room_type_id":"285","product_id":"1085","siteminder_id":"BDC-2551073653","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":"101118","customer_id":"101118","source_of_creation":"Booking.com","reservation_created_date":"2020-05-17 23:56:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"43.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3094894","reservation_id":"94177","confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"100.61,100.61,100.61,100.61","nightly_discount":"0,0,0,0","subtotal":"402.44","grand_total":"454.76","paid_amount":"454.76","room_type_id":"302","product_id":"1138","siteminder_id":"EXP-1661980243","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101169","customer_id":"101169","source_of_creation":"Expedia","reservation_created_date":"2020-04-26 22:21:08","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3094190","reservation_id":"94865","confirmation_number":"BP12531318711","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.03","nightly_discount":"0","subtotal":"96.03","grand_total":"125.29","paid_amount":"125.29","room_type_id":"298","product_id":"1133","siteminder_id":"ABB-HMKE3HB2CZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"96.03","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101057","customer_id":"101260","source_of_creation":"Airbnb","reservation_created_date":"2020-05-16 15:25:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"13.42","commision_charges":"2.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.03","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3095188","reservation_id":"94822","confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"144.54,144.54,144.54","nightly_discount":"0.00,18.00,7.38","subtotal":"433.62","grand_total":"461.31","paid_amount":"461.32","room_type_id":"289","product_id":"1112","siteminder_id":"GCC-0008100080-064","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":"59773","customer_id":"59773","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-05-15 03:00:11","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"144.54","currentDayDiscount":"7.38","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094255","reservation_id":"94874","confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"142.55,142.55,142.55,142.55,142.55,209.05","nightly_discount":"0,0,0,0,0,0","subtotal":"921.80","grand_total":"1041.64","paid_amount":"1041.64","room_type_id":"289","product_id":"1109","siteminder_id":"GCC-0008300082-064","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101066","customer_id":"101066","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-05-16 18:20:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.55","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"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3095257","reservation_id":"94886","confirmation_number":"BV12437941144","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16","nightly_discount":"0","subtotal":"86.16","grand_total":"97.36","paid_amount":"97.36","room_type_id":"289","product_id":"1095","siteminder_id":"AGO-319066994","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":"101251","customer_id":"101251","source_of_creation":"Agoda","reservation_created_date":"2020-05-17 00:04:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095320","reservation_id":"94661","confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"139.52,70.53,70.53,70.53","nightly_discount":"0,0,0,0","subtotal":"351.11","grand_total":"396.76","paid_amount":"396.76","room_type_id":"303","product_id":"1140","siteminder_id":"AGO-318367766","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101069","customer_id":"101069","source_of_creation":"Agoda","reservation_created_date":"2020-05-11 01:57:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.53","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":"3095200","reservation_id":"85521","confirmation_number":"PB12345584060","room_stay_from":"2020-05-15","room_stay_to":"2020-05-21","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.90,147.90,126.23,126.23,126.23,126.23","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"800.72","grand_total":"904.81","paid_amount":"904.81","room_type_id":"313","product_id":"1228","siteminder_id":"AGO-252881199","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":"92602","customer_id":"92602","source_of_creation":"Agoda","reservation_created_date":"2019-10-12 10:57:06","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.23","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094658","reservation_id":"94774","confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"106.56,106.56,106.56,106.56,106.56,205.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"738.38","grand_total":"834.37","paid_amount":"834.37","room_type_id":"289","product_id":"1098","siteminder_id":"AGO-318681282","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101111","customer_id":"101111","source_of_creation":"Agoda","reservation_created_date":"2020-05-14 01:28:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3095186","reservation_id":"94824","confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"144.54,144.54,144.54","nightly_discount":"0.00,0.00,7.38","subtotal":"433.62","grand_total":"481.65","paid_amount":"481.66","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101025","customer_id":"101025","source_of_creation":"FE","reservation_created_date":"2020-05-15 03:25:50","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"144.54","currentDayDiscount":"7.38","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094921","reservation_id":"94330","confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,15.23","subtotal":"297.00","grand_total":"318.40","paid_amount":"318.40","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":"100389","customer_id":"100389","source_of_creation":"FE","reservation_created_date":"2020-05-02 14:55:31","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094717","reservation_id":"94937","confirmation_number":"PB12342875159","room_stay_from":"2020-05-19","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,199.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"586.00","grand_total":"662.18","paid_amount":"662.18","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":"101128","customer_id":"101128","source_of_creation":"FE","reservation_created_date":"2020-05-18 02:54:50","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":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3094388","reservation_id":"94492","confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0","subtotal":"1386.00","grand_total":"1566.18","paid_amount":"1566.18","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100702","customer_id":"100702","source_of_creation":"PMS","reservation_created_date":"2020-05-06 15:04:19","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094905","reservation_id":"94982","confirmation_number":"PB12399443292","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101034","customer_id":"101034","source_of_creation":"PMS","reservation_created_date":"2020-05-18 20:03:15","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095105","reservation_id":"94819","confirmation_number":"BV12468763941","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"396.00","grand_total":"447.48","paid_amount":"447.48","room_type_id":"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":"101020","customer_id":"101020","source_of_creation":"PMS","reservation_created_date":"2020-05-15 00:47:37","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095132","reservation_id":"94849","confirmation_number":"PB12386197731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,75.00","nightly_discount":"0.00,0.00,0.00","subtotal":"273.00","grand_total":"308.49","paid_amount":"308.49","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101043","customer_id":"101043","source_of_creation":"PMS","reservation_created_date":"2020-05-15 19:22:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095150","reservation_id":"95045","confirmation_number":"PB12356759002","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"7.91","subtotal":"129.00","grand_total":"136.84","paid_amount":"136.84","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":"101192","customer_id":"101192","source_of_creation":"PMS","reservation_created_date":"2020-05-19 15:30:01","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"7.91","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095156","reservation_id":"94876","confirmation_number":"BP12528159222","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66483","customer_id":"66483","source_of_creation":"PMS","reservation_created_date":"2020-05-16 19:11:30","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 804","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095171","reservation_id":"95030","confirmation_number":"BP12515001767","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","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":"100857","customer_id":"100857","source_of_creation":"PMS","reservation_created_date":"2020-05-19 12:25:58","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3091290","reservation_id":"94446","confirmation_number":"PB12376871132","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.00,175.00","nightly_discount":"0.00,0.00","subtotal":"350.00","grand_total":"395.50","paid_amount":"395.50","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":"100664","customer_id":"100664","source_of_creation":"PMS","reservation_created_date":"2020-05-05 15:31:50","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"175.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093037","reservation_id":"94685","confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100579","customer_id":"100579","source_of_creation":"PMS","reservation_created_date":"2020-05-11 22:48:50","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095174","reservation_id":"94449","confirmation_number":"PB12364616732","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.00,175.00","nightly_discount":"0.00,0.00","subtotal":"350.00","grand_total":"395.50","paid_amount":"395.50","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":"100665","customer_id":"100665","source_of_creation":"PMS","reservation_created_date":"2020-05-05 15:34:38","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"175.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095309","reservation_id":"94993","confirmation_number":"BP12587223379","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"295","product_id":"1128","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":"101186","customer_id":"101186","source_of_creation":"PMS","reservation_created_date":"2020-05-18 22:31:15","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":"","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":"3092596","reservation_id":"94505","confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"159.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"804.00","grand_total":"908.52","paid_amount":"908.52","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":"81868","customer_id":"81868","source_of_creation":"PMS","reservation_created_date":"2020-05-06 20:42:31","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":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093552","reservation_id":"94455","confirmation_number":"PB12332291553","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100993","customer_id":"100993","source_of_creation":"PMS","reservation_created_date":"2020-05-05 17:44:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094295","reservation_id":"94505","confirmation_number":"PB12376730984","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,35.58","subtotal":"804.00","grand_total":"868.32","paid_amount":"868.32","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81868","customer_id":"81868","source_of_creation":"PMS","reservation_created_date":"2020-05-06 20:42:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094778","reservation_id":"94953","confirmation_number":"PB12325604710","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","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":"100976","customer_id":"100976","source_of_creation":"PMS","reservation_created_date":"2020-05-18 15:03:22","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093765","reservation_id":"94749","confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:00:14","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093770","reservation_id":"94749","confirmation_number":"BP12575897730","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:08:25","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093775","reservation_id":"94749","confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"294","product_id":"1125","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":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:11:37","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093959","reservation_id":"94749","confirmation_number":"BP12554397887","room_stay_from":"2020-05-15","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1152.00","grand_total":"1222.44","paid_amount":"1222.44","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-15 15:43:52","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095294","reservation_id":"94834","confirmation_number":"PB12344310731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00,129.00,249.00","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"894.00","grand_total":"1010.22","paid_amount":"1010.22","room_type_id":"285","product_id":"1084","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":"101022","customer_id":"101022","source_of_creation":"PMS","reservation_created_date":"2020-05-15 14:47: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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094704","reservation_id":"94932","confirmation_number":"PB12313880138","room_stay_from":"2020-05-18","room_stay_to":"2020-05-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"914.00","grand_total":"1032.82","paid_amount":"1032.82","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":"101124","customer_id":"101124","source_of_creation":"PMS","reservation_created_date":"2020-05-18 01:51:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092996","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,99.00,89.00,89.00,89.00,89.00,89.00,99.00,109.00,99.00,99.00,99.00,99.00,99.00,109.00,129.00,99.00,99.00,99.00,99.00,109.00,109.00,109.00,99.00,99.00,99.00,99.00,99.00,129.00,129.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,42.00,0.00,0.00,0.00,0.00,0.00,0.00,39.85,0.00,0.00,0.00,0.00,0.00,0.00,41.16,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"5098.00","grand_total":"5492.62","paid_amount":"5492.62","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095263","reservation_id":"94782","confirmation_number":"PB12382867699","room_stay_from":"2020-06-08","room_stay_to":"2020-06-12","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"396.00","grand_total":"447.48","paid_amount":"111.87","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":"100982","customer_id":"100982","source_of_creation":"PMS","reservation_created_date":"2020-05-14 03:05:39","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":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095070","reservation_id":"94312","confirmation_number":"BV12412555384","room_stay_from":"2020-06-16","room_stay_to":"2020-06-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"172.00,172.00,172.00,222.00,222.00,172.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"1132.00","grand_total":"1279.16","paid_amount":"194.36","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100552","customer_id":"100552","source_of_creation":"PMS","reservation_created_date":"2020-05-01 19:12:38","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3095131","reservation_id":"95045","confirmation_number":"PB12217412783","room_confirmation_number":"PB12356759002","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"1780","service_quantity":"1","customer_traveller_id":"101192","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-19 15:30:01","reservation_modified_date_time":"2020-05-19 15:30:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101192","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095169","reservation_id":"95030","confirmation_number":"BP12267737976","room_confirmation_number":"BP12515001767","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"1780","service_quantity":"1","customer_traveller_id":"100857","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-19 12:25:58","reservation_modified_date_time":"2020-05-19 17:00:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095317","reservation_id":"94661","confirmation_number":"BV12245087623","room_confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101069","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-11 01:57:09","reservation_modified_date_time":"2020-05-20 00:29:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101069","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094685","reservation_id":"94330","confirmation_number":"BV12263553621","room_confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"40,40,40","nightly_discount":"0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100389","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-18 00:30:06","reservation_modified_date_time":"2020-05-18 00:30:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100389","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095311","reservation_id":"94993","confirmation_number":"BP12256371629","room_confirmation_number":"BP12587223379","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"101186","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-20 00:00:16","reservation_modified_date_time":"2020-05-20 00:00:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101186","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092597","reservation_id":"94505","confirmation_number":"PB12215674144","room_confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"81868","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-10 14:05:00","reservation_modified_date_time":"2020-05-10 14:05:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094779","reservation_id":"94953","confirmation_number":"PB12253620233","room_confirmation_number":"PB12325604710","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","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":"100976","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-18 15:03:22","reservation_modified_date_time":"2020-05-18 15:03:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100976","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094891","reservation_id":"94177","confirmation_number":"BP12294908038","room_confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101169","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-18 17:54:51","reservation_modified_date_time":"2020-05-18 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101169","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093351","reservation_id":"94749","confirmation_number":"BV12289705702","room_confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-13 18:00:14","reservation_modified_date_time":"2020-05-13 18:00:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093358","reservation_id":"94749","confirmation_number":"BP12248443950","room_confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-13 18:11:37","reservation_modified_date_time":"2020-05-13 18:11:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094256","reservation_id":"94874","confirmation_number":"PB12233320938","room_confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","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":"1780","service_quantity":"1","customer_traveller_id":"101066","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-16 18:20:11","reservation_modified_date_time":"2020-05-16 18:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101066","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094656","reservation_id":"94774","confirmation_number":"PB12283914742","room_confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"30.00,30.00,30.00,30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101111","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 22:24:35","reservation_modified_date_time":"2020-05-17 22:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101111","canceled_nights_data":"","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095059","reservation_id":"94636","confirmation_number":"BP12262596252","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"100857","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-19 12:18:25","reservation_modified_date_time":"2020-05-19 12:25:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"100.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3094191","reservation_id":"94865","confirmation_number":"BP12229507577","room_confirmation_number":"BP12531318711","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"101057","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-16 15:25:09","reservation_modified_date_time":"2020-05-16 15:25:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101260","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3094390","reservation_id":"94492","confirmation_number":"PB12299252539","room_confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100702","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 15:04:19","reservation_modified_date_time":"2020-05-17 14:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100702","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094852","reservation_id":"94924","confirmation_number":"PB12271585569","room_confirmation_number":"PB12319593837","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","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":"101118","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-17 23:56:11","reservation_modified_date_time":"2020-05-18 17:33:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101118","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094906","reservation_id":"94982","confirmation_number":"PB12294123538","room_confirmation_number":"PB12399443292","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"101034","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 20:03:15","reservation_modified_date_time":"2020-05-18 20:03:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101034","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095106","reservation_id":"94819","confirmation_number":"BV12277324632","room_confirmation_number":"BV12468763941","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","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":"101020","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 00:47:37","reservation_modified_date_time":"2020-05-19 14:28:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101020","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095133","reservation_id":"94849","confirmation_number":"PB12238272550","room_confirmation_number":"PB12386197731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","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":"101043","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 19:22:54","reservation_modified_date_time":"2020-05-19 15:30:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101043","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095151","reservation_id":"95045","confirmation_number":"PB12236284053","room_confirmation_number":"PB12356759002","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"101192","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-19 15:30:01","reservation_modified_date_time":"2020-05-19 15:57:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101192","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095157","reservation_id":"94876","confirmation_number":"BP12294159599","room_confirmation_number":"BP12528159222","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"66483","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-16 19:11:30","reservation_modified_date_time":"2020-05-19 16:27:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66483","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095168","reservation_id":"95030","confirmation_number":"BP12258329823","room_confirmation_number":"BP12515001767","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"100857","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-19 12:25:58","reservation_modified_date_time":"2020-05-19 17:00:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095187","reservation_id":"94824","confirmation_number":"PB12251120778","room_confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"101025","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 03:25:50","reservation_modified_date_time":"2020-05-19 18:18:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101025","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095189","reservation_id":"94822","confirmation_number":"PB12278985739","room_confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"59773","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-15 03:00:11","reservation_modified_date_time":"2020-05-19 18:19:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59773","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095255","reservation_id":"94886","confirmation_number":"BV12259168337","room_confirmation_number":"BV12437941144","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"101251","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-17 00:04:09","reservation_modified_date_time":"2020-05-19 20:44:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101251","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095318","reservation_id":"94661","confirmation_number":"BV12238775538","room_confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"101069","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-11 01:57:09","reservation_modified_date_time":"2020-05-20 00:29:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101069","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3091291","reservation_id":"94446","confirmation_number":"PB12272075452","room_confirmation_number":"PB12376871132","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","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":"100664","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-05 15:31:50","reservation_modified_date_time":"2020-05-05 15:31:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100664","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093038","reservation_id":"94685","confirmation_number":"BV12246605087","room_confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100579","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 22:48:50","reservation_modified_date_time":"2020-05-11 22:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100579","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094922","reservation_id":"94330","confirmation_number":"BV12242097370","room_confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","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":"100389","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-02 14:55:31","reservation_modified_date_time":"2020-05-18 21:27:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100389","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095175","reservation_id":"94449","confirmation_number":"PB12262657891","room_confirmation_number":"PB12364616732","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","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":"100665","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-05 15:34:38","reservation_modified_date_time":"2020-05-19 17:09:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100665","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095201","reservation_id":"85521","confirmation_number":"PB12220890970","room_confirmation_number":"PB12345584060","room_stay_from":"2020-05-15","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92602","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-12 10:57:06","reservation_modified_date_time":"2020-05-19 19:19:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92602","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-80.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095312","reservation_id":"94993","confirmation_number":"BP12293528898","room_confirmation_number":"BP12587223379","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","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":"101186","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 22:31:15","reservation_modified_date_time":"2020-05-20 00:00:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101186","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092598","reservation_id":"94505","confirmation_number":"PB12288787795","room_confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","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":"81868","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 20:42:31","reservation_modified_date_time":"2020-05-10 14:05:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093551","reservation_id":"94455","confirmation_number":"PB12295516594","room_confirmation_number":"PB12332291553","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"100993","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-05 17:44:36","reservation_modified_date_time":"2020-05-14 16:22:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100993","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094296","reservation_id":"94505","confirmation_number":"PB12290064171","room_confirmation_number":"PB12376730984","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","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":"81868","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 20:42:31","reservation_modified_date_time":"2020-05-16 20:49:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094780","reservation_id":"94953","confirmation_number":"PB12211773613","room_confirmation_number":"PB12325604710","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"100976","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 15:03:22","reservation_modified_date_time":"2020-05-18 15:03:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100976","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094892","reservation_id":"94177","confirmation_number":"BP12277980546","room_confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"101169","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-26 22:21:08","reservation_modified_date_time":"2020-05-18 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101169","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093766","reservation_id":"94749","confirmation_number":"BV12216115873","room_confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:00:14","reservation_modified_date_time":"2020-05-15 13:24:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093771","reservation_id":"94749","confirmation_number":"BP12268274978","room_confirmation_number":"BP12575897730","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:08:25","reservation_modified_date_time":"2020-05-15 13:26:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093776","reservation_id":"94749","confirmation_number":"BP12250430234","room_confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:11:37","reservation_modified_date_time":"2020-05-15 13:34:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093960","reservation_id":"94749","confirmation_number":"BP12290393180","room_confirmation_number":"BP12554397887","room_stay_from":"2020-05-15","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 15:43:52","reservation_modified_date_time":"2020-05-15 15:44:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094257","reservation_id":"94874","confirmation_number":"PB12237490259","room_confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","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":"101066","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-16 18:20:11","reservation_modified_date_time":"2020-05-16 18:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101066","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094657","reservation_id":"94774","confirmation_number":"PB12290577030","room_confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","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":"101111","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-14 01:28:09","reservation_modified_date_time":"2020-05-17 22:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101111","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094718","reservation_id":"94937","confirmation_number":"PB12246182624","room_confirmation_number":"PB12342875159","room_stay_from":"2020-05-19","room_stay_to":"2020-05-23","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":"101128","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 02:54:50","reservation_modified_date_time":"2020-05-18 02:54:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101128","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095295","reservation_id":"94834","confirmation_number":"PB12217617283","room_confirmation_number":"PB12344310731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","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":"101022","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 14:47:17","reservation_modified_date_time":"2020-05-19 23:14:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101022","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094705","reservation_id":"94932","confirmation_number":"PB12264018112","room_confirmation_number":"PB12313880138","room_stay_from":"2020-05-18","room_stay_to":"2020-05-24","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":"101124","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 01:51:42","reservation_modified_date_time":"2020-05-18 01:51:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101124","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092997","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"624.00","grand_total":"705.12","paid_amount":"705.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-05-11 20:29:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095265","reservation_id":"94782","confirmation_number":"PB12279382902","room_confirmation_number":"PB12382867699","room_stay_from":"2020-06-08","room_stay_to":"2020-06-12","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":"100982","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-14 03:05:39","reservation_modified_date_time":"2020-05-19 21:04:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100982","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095072","reservation_id":"94312","confirmation_number":"BV12276247197","room_confirmation_number":"BV12412555384","room_stay_from":"2020-06-16","room_stay_to":"2020-06-22","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100552","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-01 19:12:38","reservation_modified_date_time":"2020-05-19 13:00:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100552","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3094261","reservation_id":"94876","confirmation_number":"BP12290134044","room_confirmation_number":"BP12528159222","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"180.00","nightly_discount":"0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-16 19:11:30","reservation_modified_date_time":"2020-05-16 19:11:30","customer_id":"66483","parentCustTravId":"66483","customer_traveller_id":"66483","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"180.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095104","reservation_id":"94932","confirmation_number":"PB12286130035","room_confirmation_number":"PB12313880138","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1192","service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 14:26:14","reservation_modified_date_time":"2020-05-19 14:26:14","customer_id":"101124","parentCustTravId":"101124","customer_traveller_id":"101124","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095107","reservation_id":"94932","confirmation_number":"PB12260546620","room_confirmation_number":"PB12313880138","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1192","service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 14:42:41","reservation_modified_date_time":"2020-05-19 14:42:41","customer_id":"101124","parentCustTravId":"101124","customer_traveller_id":"101124","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095136","reservation_id":"94749","confirmation_number":"BP12229667143","room_confirmation_number":"BP12575897730","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":"60.00","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 15:39:46","reservation_modified_date_time":"2020-05-19 15:39:46","customer_id":"100951","parentCustTravId":"100951","customer_traveller_id":"100951","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"56.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095147","reservation_id":"95048","confirmation_number":"BP12263902602","room_confirmation_number":"BP12554673457","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 15:50:02","reservation_modified_date_time":"2020-05-19 15:50:02","customer_id":"101235","parentCustTravId":"101235","customer_traveller_id":"101235","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095152","reservation_id":"95045","confirmation_number":"PB12275931633","room_confirmation_number":"PB12356759002","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":"100.00","paid_amount":"0.00","product_id":"2010","service_quantity":"10","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 15:57:51","reservation_modified_date_time":"2020-05-19 15:57:51","customer_id":"101192","parentCustTravId":"101192","customer_traveller_id":"101192","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"93.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095170","reservation_id":"95030","confirmation_number":"BP12218251780","room_confirmation_number":"BP12515001767","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.01","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 16:38:35","reservation_modified_date_time":"2020-05-19 17:00:16","customer_id":"100857","parentCustTravId":"100857","customer_traveller_id":"100857","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"28.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095198","reservation_id":"94953","confirmation_number":"PB12216021789","room_confirmation_number":"PB12325604710","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 18:59:14","reservation_modified_date_time":"2020-05-19 18:59:14","customer_id":"100976","parentCustTravId":"100976","customer_traveller_id":"100976","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"28.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095199","reservation_id":"94749","confirmation_number":"BV12215456568","room_confirmation_number":"BV12490814010","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":"60.00","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 19:18:43","reservation_modified_date_time":"2020-05-19 19:18:43","customer_id":"100951","parentCustTravId":"100951","customer_traveller_id":"100951","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"56.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095256","reservation_id":"94886","confirmation_number":"PB12229524425","room_confirmation_number":"BV12437941144","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 20:39:54","reservation_modified_date_time":"2020-05-19 20:44:40","customer_id":"101251","parentCustTravId":"101251","customer_traveller_id":"101251","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095289","reservation_id":"94865","confirmation_number":"BP12286167731","room_confirmation_number":"BP12531318711","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"39.82","grand_total":"45.00","paid_amount":"45.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 22:45:38","reservation_modified_date_time":"2020-05-19 22:45:38","customer_id":"101260","parentCustTravId":"101057","customer_traveller_id":"101057","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"39.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095313","reservation_id":"94330","confirmation_number":"BV12228898442","room_confirmation_number":"BV12436776795","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":"50.00","paid_amount":"0.00","product_id":"2010","service_quantity":"5","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-20 00:10:30","reservation_modified_date_time":"2020-05-20 00:10:30","customer_id":"100389","parentCustTravId":"100389","customer_traveller_id":"100389","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"46.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095179","reservation_id":"95051","confirmation_number":"PB12227758409","room_confirmation_number":"PB12378719033","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 17:31:28","reservation_modified_date_time":"2020-05-19 17:31:28","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095303","reservation_id":"95081","confirmation_number":"PB12281111728","room_confirmation_number":"PB12338826359","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":null,"service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 23:27:31","reservation_modified_date_time":"2020-05-19 23:27:31","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095304","reservation_id":"95081","confirmation_number":"PB12230187011","room_confirmation_number":"PB12338826359","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"39.82","grand_total":"45.00","paid_amount":"45.00","product_id":null,"service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 23:27:31","reservation_modified_date_time":"2020-05-19 23:27:31","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"39.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3094450","reservation_id":"94692","confirmation_number":"PB12277309924","room_confirmation_number":"PB12392376188","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-17 16:59:05","reservation_modified_date_time":"2020-05-17 16:59:05","customer_id":"100892","parentCustTravId":"100892","customer_traveller_id":"100892","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-19 20:10:13","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-37.4,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3094961","reservation_id":"94592","confirmation_number":"BP12254810344","room_confirmation_number":"BP12570529801","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":"100.00","paid_amount":"0.00","product_id":"2010","service_quantity":"10","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 22:57:57","reservation_modified_date_time":"2020-05-18 22:57:57","customer_id":"101192","parentCustTravId":"101192","customer_traveller_id":"101192","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-19 15:58:21","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-93.5,"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":"3095058","reservation_id":"94636","confirmation_number":"BP12270214019","room_confirmation_number":"BP12582834053","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.01","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-14 19:53:51","reservation_modified_date_time":"2020-05-19 12:25:17","customer_id":"100857","parentCustTravId":"100857","customer_traveller_id":"100857","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-19 16:37:22","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-28.05,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3095251","reservation_id":"95068","confirmation_number":"PB12278500675","room_confirmation_number":"PB12380760776","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.50","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"4","product_name":"Stamps","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 20:33:43","reservation_modified_date_time":"2020-05-19 20:33:43","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":8,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1103","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12260697091","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3094851","reservation_id":"94924","confirmation_number":"PB12319593837","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"125.37,125.37","nightly_discount":"0,0","subtotal":"250.74","grand_total":"283.33","paid_amount":"283.33","room_type_id":"285","product_id":"1085","siteminder_id":"BDC-2551073653","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":"101118","customer_id":"101118","source_of_creation":"Booking.com","reservation_created_date":"2020-05-17 23:56:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"43.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.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"}]}],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3095188","reservation_id":"94822","confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"144.54,144.54,144.54","nightly_discount":"0.00,18.00,7.38","subtotal":"433.62","grand_total":"461.31","paid_amount":"461.32","room_type_id":"289","product_id":"1112","siteminder_id":"GCC-0008100080-064","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":"59773","customer_id":"59773","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-05-15 03:00:11","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"144.54","currentDayDiscount":"7.38","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094255","reservation_id":"94874","confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"142.55,142.55,142.55,142.55,142.55,209.05","nightly_discount":"0,0,0,0,0,0","subtotal":"921.80","grand_total":"1041.64","paid_amount":"1041.64","room_type_id":"289","product_id":"1109","siteminder_id":"GCC-0008300082-064","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101066","customer_id":"101066","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-05-16 18:20:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.55","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"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3095200","reservation_id":"85521","confirmation_number":"PB12345584060","room_stay_from":"2020-05-15","room_stay_to":"2020-05-21","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.90,147.90,126.23,126.23,126.23,126.23","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"800.72","grand_total":"904.81","paid_amount":"904.81","room_type_id":"313","product_id":"1228","siteminder_id":"AGO-252881199","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":"92602","customer_id":"92602","source_of_creation":"Agoda","reservation_created_date":"2019-10-12 10:57:06","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.23","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094658","reservation_id":"94774","confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"106.56,106.56,106.56,106.56,106.56,205.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"738.38","grand_total":"834.37","paid_amount":"834.37","room_type_id":"289","product_id":"1098","siteminder_id":"AGO-318681282","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101111","customer_id":"101111","source_of_creation":"Agoda","reservation_created_date":"2020-05-14 01:28:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3095186","reservation_id":"94824","confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"144.54,144.54,144.54","nightly_discount":"0.00,0.00,7.38","subtotal":"433.62","grand_total":"481.65","paid_amount":"481.66","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101025","customer_id":"101025","source_of_creation":"FE","reservation_created_date":"2020-05-15 03:25:50","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"144.54","currentDayDiscount":"7.38","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094717","reservation_id":"94937","confirmation_number":"PB12342875159","room_stay_from":"2020-05-19","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,199.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"586.00","grand_total":"662.18","paid_amount":"662.18","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":"101128","customer_id":"101128","source_of_creation":"FE","reservation_created_date":"2020-05-18 02:54:50","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":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3094388","reservation_id":"94492","confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0","subtotal":"1386.00","grand_total":"1566.18","paid_amount":"1566.18","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100702","customer_id":"100702","source_of_creation":"PMS","reservation_created_date":"2020-05-06 15:04:19","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094905","reservation_id":"94982","confirmation_number":"PB12399443292","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101034","customer_id":"101034","source_of_creation":"PMS","reservation_created_date":"2020-05-18 20:03:15","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095132","reservation_id":"94849","confirmation_number":"PB12386197731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,75.00","nightly_discount":"0.00,0.00,0.00","subtotal":"273.00","grand_total":"308.49","paid_amount":"308.49","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101043","customer_id":"101043","source_of_creation":"PMS","reservation_created_date":"2020-05-15 19:22:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095150","reservation_id":"95045","confirmation_number":"PB12356759002","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"7.91","subtotal":"129.00","grand_total":"136.84","paid_amount":"136.84","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":"101192","customer_id":"101192","source_of_creation":"PMS","reservation_created_date":"2020-05-19 15:30:01","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"7.91","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3091290","reservation_id":"94446","confirmation_number":"PB12376871132","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.00,175.00","nightly_discount":"0.00,0.00","subtotal":"350.00","grand_total":"395.50","paid_amount":"395.50","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":"100664","customer_id":"100664","source_of_creation":"PMS","reservation_created_date":"2020-05-05 15:31:50","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"175.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095174","reservation_id":"94449","confirmation_number":"PB12364616732","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.00,175.00","nightly_discount":"0.00,0.00","subtotal":"350.00","grand_total":"395.50","paid_amount":"395.50","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":"100665","customer_id":"100665","source_of_creation":"PMS","reservation_created_date":"2020-05-05 15:34:38","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"175.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092596","reservation_id":"94505","confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"159.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"804.00","grand_total":"908.52","paid_amount":"908.52","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":"81868","customer_id":"81868","source_of_creation":"PMS","reservation_created_date":"2020-05-06 20:42:31","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":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093552","reservation_id":"94455","confirmation_number":"PB12332291553","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100993","customer_id":"100993","source_of_creation":"PMS","reservation_created_date":"2020-05-05 17:44:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094295","reservation_id":"94505","confirmation_number":"PB12376730984","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,35.58","subtotal":"804.00","grand_total":"868.32","paid_amount":"868.32","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81868","customer_id":"81868","source_of_creation":"PMS","reservation_created_date":"2020-05-06 20:42:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094778","reservation_id":"94953","confirmation_number":"PB12325604710","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","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":"100976","customer_id":"100976","source_of_creation":"PMS","reservation_created_date":"2020-05-18 15:03:22","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095294","reservation_id":"94834","confirmation_number":"PB12344310731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00,129.00,249.00","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"894.00","grand_total":"1010.22","paid_amount":"1010.22","room_type_id":"285","product_id":"1084","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":"101022","customer_id":"101022","source_of_creation":"PMS","reservation_created_date":"2020-05-15 14:47: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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094704","reservation_id":"94932","confirmation_number":"PB12313880138","room_stay_from":"2020-05-18","room_stay_to":"2020-05-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"914.00","grand_total":"1032.82","paid_amount":"1032.82","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":"101124","customer_id":"101124","source_of_creation":"PMS","reservation_created_date":"2020-05-18 01:51:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092996","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,99.00,89.00,89.00,89.00,89.00,89.00,99.00,109.00,99.00,99.00,99.00,99.00,99.00,109.00,129.00,99.00,99.00,99.00,99.00,109.00,109.00,109.00,99.00,99.00,99.00,99.00,99.00,129.00,129.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,42.00,0.00,0.00,0.00,0.00,0.00,0.00,39.85,0.00,0.00,0.00,0.00,0.00,0.00,41.16,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"5098.00","grand_total":"5492.62","paid_amount":"5492.62","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095263","reservation_id":"94782","confirmation_number":"PB12382867699","room_stay_from":"2020-06-08","room_stay_to":"2020-06-12","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"396.00","grand_total":"447.48","paid_amount":"111.87","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":"100982","customer_id":"100982","source_of_creation":"PMS","reservation_created_date":"2020-05-14 03:05:39","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":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3095131","reservation_id":"95045","confirmation_number":"PB12217412783","room_confirmation_number":"PB12356759002","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"1780","service_quantity":"1","customer_traveller_id":"101192","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-19 15:30:01","reservation_modified_date_time":"2020-05-19 15:30:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101192","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092597","reservation_id":"94505","confirmation_number":"PB12215674144","room_confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"81868","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-10 14:05:00","reservation_modified_date_time":"2020-05-10 14:05:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094779","reservation_id":"94953","confirmation_number":"PB12253620233","room_confirmation_number":"PB12325604710","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","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":"100976","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-18 15:03:22","reservation_modified_date_time":"2020-05-18 15:03:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100976","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094256","reservation_id":"94874","confirmation_number":"PB12233320938","room_confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","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":"1780","service_quantity":"1","customer_traveller_id":"101066","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-16 18:20:11","reservation_modified_date_time":"2020-05-16 18:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101066","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094656","reservation_id":"94774","confirmation_number":"PB12283914742","room_confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"30.00,30.00,30.00,30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101111","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 22:24:35","reservation_modified_date_time":"2020-05-17 22:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101111","canceled_nights_data":"","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3094390","reservation_id":"94492","confirmation_number":"PB12299252539","room_confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100702","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 15:04:19","reservation_modified_date_time":"2020-05-17 14:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100702","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094852","reservation_id":"94924","confirmation_number":"PB12271585569","room_confirmation_number":"PB12319593837","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","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":"101118","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-17 23:56:11","reservation_modified_date_time":"2020-05-18 17:33:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101118","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094906","reservation_id":"94982","confirmation_number":"PB12294123538","room_confirmation_number":"PB12399443292","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"101034","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 20:03:15","reservation_modified_date_time":"2020-05-18 20:03:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101034","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095133","reservation_id":"94849","confirmation_number":"PB12238272550","room_confirmation_number":"PB12386197731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","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":"101043","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 19:22:54","reservation_modified_date_time":"2020-05-19 15:30:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101043","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095151","reservation_id":"95045","confirmation_number":"PB12236284053","room_confirmation_number":"PB12356759002","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"101192","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-19 15:30:01","reservation_modified_date_time":"2020-05-19 15:57:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101192","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095187","reservation_id":"94824","confirmation_number":"PB12251120778","room_confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"101025","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 03:25:50","reservation_modified_date_time":"2020-05-19 18:18:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101025","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095189","reservation_id":"94822","confirmation_number":"PB12278985739","room_confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"59773","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-15 03:00:11","reservation_modified_date_time":"2020-05-19 18:19:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59773","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3091291","reservation_id":"94446","confirmation_number":"PB12272075452","room_confirmation_number":"PB12376871132","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","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":"100664","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-05 15:31:50","reservation_modified_date_time":"2020-05-05 15:31:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100664","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095175","reservation_id":"94449","confirmation_number":"PB12262657891","room_confirmation_number":"PB12364616732","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","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":"100665","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-05 15:34:38","reservation_modified_date_time":"2020-05-19 17:09:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100665","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095201","reservation_id":"85521","confirmation_number":"PB12220890970","room_confirmation_number":"PB12345584060","room_stay_from":"2020-05-15","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92602","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-12 10:57:06","reservation_modified_date_time":"2020-05-19 19:19:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92602","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-80.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092598","reservation_id":"94505","confirmation_number":"PB12288787795","room_confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","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":"81868","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 20:42:31","reservation_modified_date_time":"2020-05-10 14:05:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093551","reservation_id":"94455","confirmation_number":"PB12295516594","room_confirmation_number":"PB12332291553","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"100993","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-05 17:44:36","reservation_modified_date_time":"2020-05-14 16:22:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100993","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094296","reservation_id":"94505","confirmation_number":"PB12290064171","room_confirmation_number":"PB12376730984","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","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":"81868","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 20:42:31","reservation_modified_date_time":"2020-05-16 20:49:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094780","reservation_id":"94953","confirmation_number":"PB12211773613","room_confirmation_number":"PB12325604710","room_stay_from":"2020-05-19","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"100976","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 15:03:22","reservation_modified_date_time":"2020-05-18 15:03:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100976","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094257","reservation_id":"94874","confirmation_number":"PB12237490259","room_confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","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":"101066","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-16 18:20:11","reservation_modified_date_time":"2020-05-16 18:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101066","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094657","reservation_id":"94774","confirmation_number":"PB12290577030","room_confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","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":"101111","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-14 01:28:09","reservation_modified_date_time":"2020-05-17 22:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101111","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094718","reservation_id":"94937","confirmation_number":"PB12246182624","room_confirmation_number":"PB12342875159","room_stay_from":"2020-05-19","room_stay_to":"2020-05-23","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":"101128","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 02:54:50","reservation_modified_date_time":"2020-05-18 02:54:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101128","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095295","reservation_id":"94834","confirmation_number":"PB12217617283","room_confirmation_number":"PB12344310731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","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":"101022","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 14:47:17","reservation_modified_date_time":"2020-05-19 23:14:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101022","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094705","reservation_id":"94932","confirmation_number":"PB12264018112","room_confirmation_number":"PB12313880138","room_stay_from":"2020-05-18","room_stay_to":"2020-05-24","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":"101124","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 01:51:42","reservation_modified_date_time":"2020-05-18 01:51:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101124","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092997","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"624.00","grand_total":"705.12","paid_amount":"705.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-05-11 20:29:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095265","reservation_id":"94782","confirmation_number":"PB12279382902","room_confirmation_number":"PB12382867699","room_stay_from":"2020-06-08","room_stay_to":"2020-06-12","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":"100982","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-14 03:05:39","reservation_modified_date_time":"2020-05-19 21:04:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100982","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3095104","reservation_id":"94932","confirmation_number":"PB12286130035","room_confirmation_number":"PB12313880138","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1192","service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 14:26:14","reservation_modified_date_time":"2020-05-19 14:26:14","customer_id":"101124","parentCustTravId":"101124","customer_traveller_id":"101124","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095107","reservation_id":"94932","confirmation_number":"PB12260546620","room_confirmation_number":"PB12313880138","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1192","service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 14:42:41","reservation_modified_date_time":"2020-05-19 14:42:41","customer_id":"101124","parentCustTravId":"101124","customer_traveller_id":"101124","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095152","reservation_id":"95045","confirmation_number":"PB12275931633","room_confirmation_number":"PB12356759002","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":"100.00","paid_amount":"0.00","product_id":"2010","service_quantity":"10","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 15:57:51","reservation_modified_date_time":"2020-05-19 15:57:51","customer_id":"101192","parentCustTravId":"101192","customer_traveller_id":"101192","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"93.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095198","reservation_id":"94953","confirmation_number":"PB12216021789","room_confirmation_number":"PB12325604710","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 18:59:14","reservation_modified_date_time":"2020-05-19 18:59:14","customer_id":"100976","parentCustTravId":"100976","customer_traveller_id":"100976","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"28.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095179","reservation_id":"95051","confirmation_number":"PB12227758409","room_confirmation_number":"PB12378719033","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 17:31:28","reservation_modified_date_time":"2020-05-19 17:31:28","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095303","reservation_id":"95081","confirmation_number":"PB12281111728","room_confirmation_number":"PB12338826359","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":null,"service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 23:27:31","reservation_modified_date_time":"2020-05-19 23:27:31","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095304","reservation_id":"95081","confirmation_number":"PB12230187011","room_confirmation_number":"PB12338826359","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"39.82","grand_total":"45.00","paid_amount":"45.00","product_id":null,"service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 23:27:31","reservation_modified_date_time":"2020-05-19 23:27:31","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"39.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3094450","reservation_id":"94692","confirmation_number":"PB12277309924","room_confirmation_number":"PB12392376188","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-17 16:59:05","reservation_modified_date_time":"2020-05-17 16:59:05","customer_id":"100892","parentCustTravId":"100892","customer_traveller_id":"100892","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-19 20:10:13","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-37.4,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3095251","reservation_id":"95068","confirmation_number":"PB12278500675","room_confirmation_number":"PB12380760776","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.50","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"4","product_name":"Stamps","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 20:33:43","reservation_modified_date_time":"2020-05-19 20:33:43","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":2,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1219","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BV12245084272","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3095257","reservation_id":"94886","confirmation_number":"BV12437941144","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16","nightly_discount":"0","subtotal":"86.16","grand_total":"97.36","paid_amount":"97.36","room_type_id":"289","product_id":"1095","siteminder_id":"AGO-319066994","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":"101251","customer_id":"101251","source_of_creation":"Agoda","reservation_created_date":"2020-05-17 00:04:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095320","reservation_id":"94661","confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"139.52,70.53,70.53,70.53","nightly_discount":"0,0,0,0","subtotal":"351.11","grand_total":"396.76","paid_amount":"396.76","room_type_id":"303","product_id":"1140","siteminder_id":"AGO-318367766","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101069","customer_id":"101069","source_of_creation":"Agoda","reservation_created_date":"2020-05-11 01:57:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.53","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3094921","reservation_id":"94330","confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,15.23","subtotal":"297.00","grand_total":"318.40","paid_amount":"318.40","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":"100389","customer_id":"100389","source_of_creation":"FE","reservation_created_date":"2020-05-02 14:55:31","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3095105","reservation_id":"94819","confirmation_number":"BV12468763941","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"396.00","grand_total":"447.48","paid_amount":"447.48","room_type_id":"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":"101020","customer_id":"101020","source_of_creation":"PMS","reservation_created_date":"2020-05-15 00:47:37","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093037","reservation_id":"94685","confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100579","customer_id":"100579","source_of_creation":"PMS","reservation_created_date":"2020-05-11 22:48:50","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093765","reservation_id":"94749","confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:00:14","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095070","reservation_id":"94312","confirmation_number":"BV12412555384","room_stay_from":"2020-06-16","room_stay_to":"2020-06-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"172.00,172.00,172.00,222.00,222.00,172.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"1132.00","grand_total":"1279.16","paid_amount":"194.36","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100552","customer_id":"100552","source_of_creation":"PMS","reservation_created_date":"2020-05-01 19:12:38","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3095317","reservation_id":"94661","confirmation_number":"BV12245087623","room_confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101069","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-11 01:57:09","reservation_modified_date_time":"2020-05-20 00:29:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101069","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094685","reservation_id":"94330","confirmation_number":"BV12263553621","room_confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"40,40,40","nightly_discount":"0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100389","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-18 00:30:06","reservation_modified_date_time":"2020-05-18 00:30:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100389","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093351","reservation_id":"94749","confirmation_number":"BV12289705702","room_confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-13 18:00:14","reservation_modified_date_time":"2020-05-13 18:00:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3095106","reservation_id":"94819","confirmation_number":"BV12277324632","room_confirmation_number":"BV12468763941","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","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":"101020","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 00:47:37","reservation_modified_date_time":"2020-05-19 14:28:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101020","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095255","reservation_id":"94886","confirmation_number":"BV12259168337","room_confirmation_number":"BV12437941144","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"101251","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-17 00:04:09","reservation_modified_date_time":"2020-05-19 20:44:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101251","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095318","reservation_id":"94661","confirmation_number":"BV12238775538","room_confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"101069","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-11 01:57:09","reservation_modified_date_time":"2020-05-20 00:29:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101069","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093038","reservation_id":"94685","confirmation_number":"BV12246605087","room_confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100579","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 22:48:50","reservation_modified_date_time":"2020-05-11 22:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100579","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094922","reservation_id":"94330","confirmation_number":"BV12242097370","room_confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","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":"100389","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-02 14:55:31","reservation_modified_date_time":"2020-05-18 21:27:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100389","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093766","reservation_id":"94749","confirmation_number":"BV12216115873","room_confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:00:14","reservation_modified_date_time":"2020-05-15 13:24:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095072","reservation_id":"94312","confirmation_number":"BV12276247197","room_confirmation_number":"BV12412555384","room_stay_from":"2020-06-16","room_stay_to":"2020-06-22","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100552","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-01 19:12:38","reservation_modified_date_time":"2020-05-19 13:00:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100552","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3095199","reservation_id":"94749","confirmation_number":"BV12215456568","room_confirmation_number":"BV12490814010","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":"60.00","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 19:18:43","reservation_modified_date_time":"2020-05-19 19:18:43","customer_id":"100951","parentCustTravId":"100951","customer_traveller_id":"100951","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"56.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095256","reservation_id":"94886","confirmation_number":"PB12229524425","room_confirmation_number":"BV12437941144","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 20:39:54","reservation_modified_date_time":"2020-05-19 20:44:40","customer_id":"101251","parentCustTravId":"101251","customer_traveller_id":"101251","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095313","reservation_id":"94330","confirmation_number":"BV12228898442","room_confirmation_number":"BV12436776795","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":"50.00","paid_amount":"0.00","product_id":"2010","service_quantity":"5","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-20 00:10:30","reservation_modified_date_time":"2020-05-20 00:10:30","customer_id":"100389","parentCustTravId":"100389","customer_traveller_id":"100389","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"46.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3094894","reservation_id":"94177","confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"100.61,100.61,100.61,100.61","nightly_discount":"0,0,0,0","subtotal":"402.44","grand_total":"454.76","paid_amount":"454.76","room_type_id":"302","product_id":"1138","siteminder_id":"EXP-1661980243","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101169","customer_id":"101169","source_of_creation":"Expedia","reservation_created_date":"2020-04-26 22:21:08","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3094190","reservation_id":"94865","confirmation_number":"BP12531318711","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.03","nightly_discount":"0","subtotal":"96.03","grand_total":"125.29","paid_amount":"125.29","room_type_id":"298","product_id":"1133","siteminder_id":"ABB-HMKE3HB2CZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"96.03","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101057","customer_id":"101260","source_of_creation":"Airbnb","reservation_created_date":"2020-05-16 15:25:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"13.42","commision_charges":"2.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.03","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3095156","reservation_id":"94876","confirmation_number":"BP12528159222","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66483","customer_id":"66483","source_of_creation":"PMS","reservation_created_date":"2020-05-16 19:11:30","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 804","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095171","reservation_id":"95030","confirmation_number":"BP12515001767","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","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":"100857","customer_id":"100857","source_of_creation":"PMS","reservation_created_date":"2020-05-19 12:25:58","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3095309","reservation_id":"94993","confirmation_number":"BP12587223379","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"295","product_id":"1128","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":"101186","customer_id":"101186","source_of_creation":"PMS","reservation_created_date":"2020-05-18 22:31:15","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":"","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":"3093770","reservation_id":"94749","confirmation_number":"BP12575897730","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:08:25","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093775","reservation_id":"94749","confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"294","product_id":"1125","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":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:11:37","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093959","reservation_id":"94749","confirmation_number":"BP12554397887","room_stay_from":"2020-05-15","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1152.00","grand_total":"1222.44","paid_amount":"1222.44","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-15 15:43:52","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3095169","reservation_id":"95030","confirmation_number":"BP12267737976","room_confirmation_number":"BP12515001767","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"1780","service_quantity":"1","customer_traveller_id":"100857","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-19 12:25:58","reservation_modified_date_time":"2020-05-19 17:00:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095311","reservation_id":"94993","confirmation_number":"BP12256371629","room_confirmation_number":"BP12587223379","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"101186","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-20 00:00:16","reservation_modified_date_time":"2020-05-20 00:00:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101186","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094891","reservation_id":"94177","confirmation_number":"BP12294908038","room_confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101169","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-18 17:54:51","reservation_modified_date_time":"2020-05-18 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101169","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093358","reservation_id":"94749","confirmation_number":"BP12248443950","room_confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-13 18:11:37","reservation_modified_date_time":"2020-05-13 18:11:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095059","reservation_id":"94636","confirmation_number":"BP12262596252","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"100857","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-19 12:18:25","reservation_modified_date_time":"2020-05-19 12:25:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"100.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3094191","reservation_id":"94865","confirmation_number":"BP12229507577","room_confirmation_number":"BP12531318711","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"101057","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-16 15:25:09","reservation_modified_date_time":"2020-05-16 15:25:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101260","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3095157","reservation_id":"94876","confirmation_number":"BP12294159599","room_confirmation_number":"BP12528159222","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"66483","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-16 19:11:30","reservation_modified_date_time":"2020-05-19 16:27:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66483","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095168","reservation_id":"95030","confirmation_number":"BP12258329823","room_confirmation_number":"BP12515001767","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","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":"100857","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-19 12:25:58","reservation_modified_date_time":"2020-05-19 17:00:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095312","reservation_id":"94993","confirmation_number":"BP12293528898","room_confirmation_number":"BP12587223379","room_stay_from":"2020-05-19","room_stay_to":"2020-05-21","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":"101186","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 22:31:15","reservation_modified_date_time":"2020-05-20 00:00:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101186","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094892","reservation_id":"94177","confirmation_number":"BP12277980546","room_confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"101169","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-26 22:21:08","reservation_modified_date_time":"2020-05-18 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101169","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093771","reservation_id":"94749","confirmation_number":"BP12268274978","room_confirmation_number":"BP12575897730","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:08:25","reservation_modified_date_time":"2020-05-15 13:26:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093776","reservation_id":"94749","confirmation_number":"BP12250430234","room_confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:11:37","reservation_modified_date_time":"2020-05-15 13:34:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093960","reservation_id":"94749","confirmation_number":"BP12290393180","room_confirmation_number":"BP12554397887","room_stay_from":"2020-05-15","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 15:43:52","reservation_modified_date_time":"2020-05-15 15:44:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3094261","reservation_id":"94876","confirmation_number":"BP12290134044","room_confirmation_number":"BP12528159222","room_stay_from":"2020-05-19","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"180.00","nightly_discount":"0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-16 19:11:30","reservation_modified_date_time":"2020-05-16 19:11:30","customer_id":"66483","parentCustTravId":"66483","customer_traveller_id":"66483","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"180.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095136","reservation_id":"94749","confirmation_number":"BP12229667143","room_confirmation_number":"BP12575897730","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":"60.00","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 15:39:46","reservation_modified_date_time":"2020-05-19 15:39:46","customer_id":"100951","parentCustTravId":"100951","customer_traveller_id":"100951","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"56.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095147","reservation_id":"95048","confirmation_number":"BP12263902602","room_confirmation_number":"BP12554673457","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 15:50:02","reservation_modified_date_time":"2020-05-19 15:50:02","customer_id":"101235","parentCustTravId":"101235","customer_traveller_id":"101235","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3095170","reservation_id":"95030","confirmation_number":"BP12218251780","room_confirmation_number":"BP12515001767","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.01","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 16:38:35","reservation_modified_date_time":"2020-05-19 17:00:16","customer_id":"100857","parentCustTravId":"100857","customer_traveller_id":"100857","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"28.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3095289","reservation_id":"94865","confirmation_number":"BP12286167731","room_confirmation_number":"BP12531318711","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"39.82","grand_total":"45.00","paid_amount":"45.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 22:45:38","reservation_modified_date_time":"2020-05-19 22:45:38","customer_id":"101260","parentCustTravId":"101057","customer_traveller_id":"101057","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"39.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3094961","reservation_id":"94592","confirmation_number":"BP12254810344","room_confirmation_number":"BP12570529801","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":"100.00","paid_amount":"0.00","product_id":"2010","service_quantity":"10","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 22:57:57","reservation_modified_date_time":"2020-05-18 22:57:57","customer_id":"101192","parentCustTravId":"101192","customer_traveller_id":"101192","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-19 15:58:21","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-93.5,"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":"3095058","reservation_id":"94636","confirmation_number":"BP12270214019","room_confirmation_number":"BP12582834053","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.01","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-14 19:53:51","reservation_modified_date_time":"2020-05-19 12:25:17","customer_id":"100857","parentCustTravId":"100857","customer_traveller_id":"100857","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-19 16:37:22","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-28.05,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}