{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-11-08","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":24,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5330952","reservation_id":"124599","confirmation_number":"PB12331522567","room_stay_from":"2021-11-03","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.27,179.27,212.66,212.66,194.86,194.86,194.86","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1368.44","grand_total":"1546.34","paid_amount":"1546.34","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-3728219191","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":"133142","customer_id":"133142","source_of_creation":"Booking.com","reservation_created_date":"2021-10-19 01:14:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"226.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"194.86","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":"5331494","reservation_id":"122363","confirmation_number":"PB12351801479","room_stay_from":"2021-11-05","room_stay_to":"2021-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"235.06,235.06,215.29,215.29,215.29,215.29,388.5,424.09","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2143.87","grand_total":"2422.57","paid_amount":"2422.57","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-2205139040","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122316","customer_id":"122316","source_of_creation":"Booking.com","reservation_created_date":"2021-09-01 19:26:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"357.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"215.29","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332084","reservation_id":"125111","confirmation_number":"PB12374682600","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.44,222.44","nightly_discount":"0,0","subtotal":"444.88","grand_total":"502.71","paid_amount":"502.71","room_type_id":"287","product_id":"1089","siteminder_id":"BDC-3029207142","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133398","customer_id":"133398","source_of_creation":"Booking.com","reservation_created_date":"2021-11-06 03:54:39","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"72.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"222.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332153","reservation_id":"125171","confirmation_number":"PB12377248361","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"104.92,104.92","nightly_discount":"0,0","subtotal":"209.84","grand_total":"237.12","paid_amount":"237.12","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-3442289660","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133410","customer_id":"133410","source_of_creation":"Booking.com","reservation_created_date":"2021-11-07 21:38:15","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"37.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"104.92","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332345","reservation_id":"125142","confirmation_number":"PB12363196475","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"121.01,129.00","nightly_discount":"0.00,7.55","subtotal":"250.01","grand_total":"273.98","paid_amount":"273.98","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-2473623440","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133418","customer_id":"133418","source_of_creation":"Booking.com","reservation_created_date":"2021-11-07 15:31:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"22.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.00","currentDayDiscount":"7.55","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332414","reservation_id":"125190","confirmation_number":"BP12595890967","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"86.87,86.87","nightly_discount":"0,0","subtotal":"173.74","grand_total":"196.32","paid_amount":"196.32","room_type_id":"302","product_id":"1138","siteminder_id":"BDC-2180317338","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":"133448","customer_id":"133448","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 04:03:32","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"52.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"86.87","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":"5332435","reservation_id":"125200","confirmation_number":"BP12541551030","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.45,80.45","nightly_discount":"0,0","subtotal":"160.90","grand_total":"181.81","paid_amount":"181.81","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-2476164757","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133454","customer_id":"133454","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 14:21:07","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","ota_service_fee_amount":"0","commision_charges":"36.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"80.45","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":"5332454","reservation_id":"125208","confirmation_number":"PB12347141882","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.19","nightly_discount":"0","subtotal":"113.19","grand_total":"127.90","paid_amount":"127.90","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2571014068","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133456","customer_id":"133456","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 17:42:29","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"19.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"113.19","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332472","reservation_id":"125176","confirmation_number":"BV12497051804","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"77.71","nightly_discount":"0","subtotal":"77.71","grand_total":"87.81","paid_amount":"87.81","room_type_id":"304","product_id":"1218","siteminder_id":"BDC-3907744020","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133411","customer_id":"133411","source_of_creation":"Booking.com","reservation_created_date":"2021-11-07 23:06:04","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"17.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"77.71","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":"5332523","reservation_id":"125205","confirmation_number":"BV12482628859","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.94","nightly_discount":"0","subtotal":"69.94","grand_total":"79.04","paid_amount":"79.04","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-3252971755","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133471","customer_id":"133471","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 17:09:45","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"16.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"69.94","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":"5332561","reservation_id":"125216","confirmation_number":"PB12347549012","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.46,79.46,79.46,143.03","nightly_discount":"0,0,0,0","subtotal":"381.41","grand_total":"430.99","paid_amount":"430.99","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-2957392964","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133480","customer_id":"133480","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 20:17:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"69.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"79.46","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":"5332594","reservation_id":"125186","confirmation_number":"BP12581472340","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.35,60.35,70.00","nightly_discount":"0.00,0.00,0.00","subtotal":"190.70","grand_total":"215.49","paid_amount":"215.49","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-2473639284","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133489","customer_id":"133489","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 02:19:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"28.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"60.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332630","reservation_id":"125231","confirmation_number":"BP12573685709","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.84,92.84","nightly_discount":"0,0","subtotal":"185.68","grand_total":"209.82","paid_amount":"209.82","room_type_id":"300","product_id":"1135","siteminder_id":"BDC-3787077290","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133496","customer_id":"133496","source_of_creation":"Booking.com","reservation_created_date":"2021-11-09 01:14:12","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"40.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"92.84","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":"5331001","reservation_id":"123577","confirmation_number":"PB12356633135","room_stay_from":"2021-11-03","room_stay_to":"2021-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"240.57,240.57,262.54,262.54,240.57,240.57,240.57,240.57,433.03,472.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2874.11","grand_total":"3247.75","paid_amount":"3247.75","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1834171790","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":"113213","customer_id":"113213","source_of_creation":"Expedia","reservation_created_date":"2021-09-24 02:34:37","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"240.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331502","reservation_id":"124833","confirmation_number":"PB12390620385","room_stay_from":"2021-11-05","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.61,186.61,170.99,170.99,170.99,170.99","nightly_discount":"0,0,0,0,0,0","subtotal":"1057.18","grand_total":"1194.61","paid_amount":"1194.61","room_type_id":"289","product_id":"1105","siteminder_id":"EXP-1849781981","collect_which":"channel_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":"133285","customer_id":"133285","source_of_creation":"Expedia","reservation_created_date":"2021-10-28 01:05:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"170.99","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":"5331821","reservation_id":"125112","confirmation_number":"BV12418050266","room_stay_from":"2021-11-06","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.23,88.36,88.36","nightly_discount":"0,0,0","subtotal":"292.95","grand_total":"331.04","paid_amount":"331.04","room_type_id":"305","product_id":"1222","siteminder_id":"EXP-1853915729","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":"133342","customer_id":"133342","source_of_creation":"Expedia","reservation_created_date":"2021-11-06 05:11:55","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":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"88.36","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":"5332463","reservation_id":"125189","confirmation_number":"BP12599094286","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"43.25","nightly_discount":"0","subtotal":"43.25","grand_total":"48.88","paid_amount":"48.88","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1854640203","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133457","customer_id":"133457","source_of_creation":"Expedia","reservation_created_date":"2021-11-08 04:01:47","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"43.25","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":"5332620","reservation_id":"124448","confirmation_number":"PB12397050697","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"298.12,298.12,298.12,536.61","nightly_discount":"0.00,0.00,0.00,60.63","subtotal":"1430.97","grand_total":"1548.48","paid_amount":"1548.48","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1843416807","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":"133495","customer_id":"133495","source_of_creation":"Expedia","reservation_created_date":"2021-10-14 02:59:13","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"298.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332626","reservation_id":"124447","confirmation_number":"PB12335520266","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"298.12,298.12,298.12,536.61","nightly_discount":"0.00,0.00,0.00,62.58","subtotal":"1430.97","grand_total":"1546.28","paid_amount":"1546.28","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1843416805","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133495","customer_id":"133495","source_of_creation":"Expedia","reservation_created_date":"2021-10-14 02:59:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"298.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5330472","reservation_id":"113397","confirmation_number":"PB12338578694","room_stay_from":"2021-11-07","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.38,111.38,111.38,111.38","nightly_discount":"0,0,0,0","subtotal":"445.52","grand_total":"503.44","paid_amount":"503.44","room_type_id":"286","product_id":"1086","siteminder_id":"GAM-R2460587057","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":"119982","customer_id":"119982","source_of_creation":"Getaroom.com","reservation_created_date":"2021-04-19 17:34:17","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"111.38","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":"5330979","reservation_id":"118584","confirmation_number":"PB12327425426","room_stay_from":"2021-11-04","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.80,105.64,105.64,96.80,96.80,96.80","nightly_discount":"0,0,0,0,0,0","subtotal":"598.48","grand_total":"676.28","paid_amount":"676.28","room_type_id":"289","product_id":"1106","siteminder_id":"GAM-R2633475304","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":"125636","customer_id":"125636","source_of_creation":"Getaroom.com","reservation_created_date":"2021-07-02 23:43:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"96.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3223859","reservation_id":"111498","confirmation_number":"PB12393284413","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,140.00,140.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"994.40","paid_amount":"994.40","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":"118062","customer_id":"118062","source_of_creation":"FE","reservation_created_date":"2021-03-28 13:50:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330625","reservation_id":"114062","confirmation_number":"PB12336156390","room_stay_from":"2021-11-02","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,221.00,221.00,201.00,201.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,66.28","subtotal":"1447.00","grand_total":"1560.21","paid_amount":"1560.21","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"67988","customer_id":"67988","source_of_creation":"FE","reservation_created_date":"2021-04-28 14:22:54","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"201.00","currentDayDiscount":"66.28","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330707","reservation_id":"113433","confirmation_number":"PB12322414188","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"162.00,162.00,162.00","nightly_discount":"0.00,0.00,0.00","subtotal":"486.00","grand_total":"549.18","paid_amount":"549.18","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":"120023","customer_id":"120023","source_of_creation":"FE","reservation_created_date":"2021-04-19 22:47:13","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"162.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331931","reservation_id":"114027","confirmation_number":"PB12357033729","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.00,158.00,158.00,138.00,138.00,138.00,138.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,47.58","subtotal":"1006.00","grand_total":"1083.02","paid_amount":"1083.02","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133220","customer_id":"133220","source_of_creation":"FE","reservation_created_date":"2021-04-27 22:27:28","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332050","reservation_id":"125162","confirmation_number":"BP12538131363","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.09,76.09","nightly_discount":"0.00,0.00","subtotal":"152.18","grand_total":"171.96","paid_amount":"85.99","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133091","customer_id":"133091","source_of_creation":"FE","reservation_created_date":"2021-11-07 19:43:48","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"76.09","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332160","reservation_id":"125178","confirmation_number":"PB12357246823","room_stay_from":"2021-11-07","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.42,104.42,104.42","nightly_discount":"0.00,0.00,0.00","subtotal":"313.26","grand_total":"353.99","paid_amount":"353.99","room_type_id":"290","product_id":"1113","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107618","customer_id":"107618","source_of_creation":"FE","reservation_created_date":"2021-11-07 23:29:36","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"104.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332211","reservation_id":"125131","confirmation_number":"BV12463819150","room_stay_from":"2021-11-07","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.69,78.69,78.69,78.69","nightly_discount":"0.00,0.00,0.00,13.27","subtotal":"314.76","grand_total":"340.68","paid_amount":"340.68","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133346","customer_id":"133346","source_of_creation":"FE","reservation_created_date":"2021-11-06 23:40:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"78.69","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3218222","reservation_id":"110417","confirmation_number":"PB12342698664","room_stay_from":"2021-11-06","room_stay_to":"2021-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,120.00,120.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"994.40","paid_amount":"994.40","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":"87086","customer_id":"87086","source_of_creation":"PMS","reservation_created_date":"2021-03-18 18:54:22","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3260470","reservation_id":"114199","confirmation_number":"PB12326180287","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,156.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"546.00","grand_total":"616.98","paid_amount":"616.98","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89546","customer_id":"89546","source_of_creation":"PMS","reservation_created_date":"2021-04-30 14:08:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330181","reservation_id":"124776","confirmation_number":"PB12365229491","room_stay_from":"2021-10-31","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.52,186.58,186.58,186.58,186.58,236.60,236.60,202.80,202.80,202.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,97.40","subtotal":"1971.44","grand_total":"2117.66","paid_amount":"2117.66","room_type_id":"289","product_id":"1108","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":"132844","customer_id":"132844","source_of_creation":"PMS","reservation_created_date":"2021-10-26 00:59:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"202.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331245","reservation_id":"102331","confirmation_number":"PB12372784524","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,140.00,140.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"994.40","paid_amount":"994.40","room_type_id":"289","product_id":"1103","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":"30198","customer_id":"30198","source_of_creation":"PMS","reservation_created_date":"2020-11-05 21:49:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331257","reservation_id":"125063","confirmation_number":"PB12338614823","room_stay_from":"2021-11-06","room_stay_to":"2021-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"192.75,132.18,132.18,132.18,132.18,237.90,202.31","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1161.68","grand_total":"1312.70","paid_amount":"1312.70","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":"133231","customer_id":"133231","source_of_creation":"PMS","reservation_created_date":"2021-11-04 18:55: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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"132.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331570","reservation_id":"125072","confirmation_number":"PB12378959924","room_stay_from":"2021-11-06","room_stay_to":"2021-11-19","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"149.99,99.00,99.00,99.00,99.00,99.00,149.99,149.99,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1439.97","grand_total":"1627.17","paid_amount":"1627.17","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110752","customer_id":"110752","source_of_creation":"PMS","reservation_created_date":"2021-11-05 00:48:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331988","reservation_id":"124966","confirmation_number":"BV12483666991","room_stay_from":"2021-11-01","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.56,61.56,61.56,61.56,110.00,115.00,80.00,80.00,80.00,80.00,95.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,16.36,0.00,0.00,0.00,0.00,0.00","subtotal":"886.24","grand_total":"982.96","paid_amount":"982.96","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133111","customer_id":"133111","source_of_creation":"PMS","reservation_created_date":"2021-11-02 00:58:54","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332088","reservation_id":"124554","confirmation_number":"PB12388937820","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"236.60,236.60","nightly_discount":"0.00,0.00","subtotal":"473.20","grand_total":"534.71","paid_amount":"534.71","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132538","customer_id":"132538","source_of_creation":"PMS","reservation_created_date":"2021-10-17 19:15:05","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"236.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332103","reservation_id":"125026","confirmation_number":"PB12388206836","room_stay_from":"2021-11-05","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.57,206.51,143.19,143.19","nightly_discount":"0.00,0.00,0.00,0","subtotal":"672.46","grand_total":"759.88","paid_amount":"759.88","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133186","customer_id":"133186","source_of_creation":"PMS","reservation_created_date":"2021-11-03 23:39:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"143.19","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332224","reservation_id":"125187","confirmation_number":"BP12510427139","room_stay_from":"2021-11-07","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00","subtotal":"300.00","grand_total":"339.00","paid_amount":"339.00","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":"133429","customer_id":"133429","source_of_creation":"PMS","reservation_created_date":"2021-11-08 02:26:25","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332244","reservation_id":"125146","confirmation_number":"PB12361115730","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.82,188.82","nightly_discount":"0.00,0","subtotal":"377.64","grand_total":"426.73","paid_amount":"426.73","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":"133372","customer_id":"133372","source_of_creation":"PMS","reservation_created_date":"2021-11-07 16:46:26","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"188.82","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332292","reservation_id":"125198","confirmation_number":"PB12318025143","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.09","nightly_discount":"0.00","subtotal":"140.09","grand_total":"158.31","paid_amount":"158.31","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":"133315","customer_id":"133315","source_of_creation":"PMS","reservation_created_date":"2021-11-08 13:01:33","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"140.09","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332302","reservation_id":"125199","confirmation_number":"BP12591302541","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.00","nightly_discount":"0.00","subtotal":"71.00","grand_total":"80.23","paid_amount":"80.23","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":"133440","customer_id":"133440","source_of_creation":"PMS","reservation_created_date":"2021-11-08 14:05:10","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":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"71.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332403","reservation_id":"124850","confirmation_number":"PB12321631070","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"219.70,219.70","nightly_discount":"0.00,0.00","subtotal":"439.40","grand_total":"496.52","paid_amount":"496.52","room_type_id":"291","product_id":"1119","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":"132936","customer_id":"132936","source_of_creation":"PMS","reservation_created_date":"2021-11-08 16:36:46","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"219.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332466","reservation_id":"125212","confirmation_number":"BP12552471545","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","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":"133459","customer_id":"133459","source_of_creation":"PMS","reservation_created_date":"2021-11-08 19:37:10","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":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332552","reservation_id":"125223","confirmation_number":"PB12358549474","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133476","customer_id":"133476","source_of_creation":"PMS","reservation_created_date":"2021-11-08 22:19:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332400","reservation_id":"124850","confirmation_number":"PB12366483367","room_stay_from":"2021-11-06","room_stay_to":"2021-11-08","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"253.50,219.70","nightly_discount":"0.00,0.00","subtotal":"473.20","grand_total":"534.71","paid_amount":"534.71","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132936","customer_id":"132936","source_of_creation":"PMS","reservation_created_date":"2021-10-28 17:57:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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":[{"room_stay_id":"3126090","reservation_id":"87088","confirmation_number":"PB12390189540","room_stay_from":"2021-11-07","room_stay_to":"2021-11-20","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.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","subtotal":"1703.00","grand_total":"1924.39","paid_amount":"148.03","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":"104956","customer_id":"104956","source_of_creation":"PMS","reservation_created_date":"2019-11-13 14:48:29","service_canceled_date_time":"2021-11-08 15:53:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_0","total_paid_amount":"148.03","sub_hotel_id":"123","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5326758","reservation_id":"124554","confirmation_number":"PB12235258106","room_confirmation_number":"PB12388937820","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"132538","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-10-17 19:15:05","reservation_modified_date_time":"2021-10-17 19:15:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132538","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330708","reservation_id":"113433","confirmation_number":"PB12248505976","room_confirmation_number":"PB12322414188","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"120023","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-11-03 12:39:17","reservation_modified_date_time":"2021-11-03 12:39:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120023","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330999","reservation_id":"123577","confirmation_number":"PB12236701275","room_confirmation_number":"PB12356633135","room_stay_from":"2021-11-03","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"113213","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-03 12:39:47","reservation_modified_date_time":"2021-11-04 00:11:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113213","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331492","reservation_id":"122363","confirmation_number":"PB12221640478","room_confirmation_number":"PB12351801479","room_stay_from":"2021-11-05","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,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":"122316","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-09-01 19:26:13","reservation_modified_date_time":"2021-11-05 20:19:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122316","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331566","reservation_id":"125072","confirmation_number":"PB12286905271","room_confirmation_number":"PB12378959924","room_stay_from":"2021-11-06","room_stay_to":"2021-11-19","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"110752","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-05 23:45:22","reservation_modified_date_time":"2021-11-05 23:45:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332339","reservation_id":"125142","confirmation_number":"PB12284669704","room_confirmation_number":"PB12363196475","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"133418","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-11-08 15:57:52","reservation_modified_date_time":"2021-11-08 15:57:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133418","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","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":"5332404","reservation_id":"124850","confirmation_number":"PB12264180373","room_confirmation_number":"PB12321631070","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"132936","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-08 16:36:46","reservation_modified_date_time":"2021-11-08 16:36:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332412","reservation_id":"125190","confirmation_number":"BP12241258217","room_confirmation_number":"BP12595890967","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"40,40","nightly_discount":"0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"133448","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-11-08 08:20:57","reservation_modified_date_time":"2021-11-08 16:54:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133448","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"125","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":"5332514","reservation_id":"125151","confirmation_number":"BP12215702909","room_confirmation_number":"BP12531057852","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"133470","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-07 18:27:29","reservation_modified_date_time":"2021-11-08 21:09:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133470","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"125","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":"5332624","reservation_id":"124447","confirmation_number":"PB12253581217","room_confirmation_number":"PB12335520266","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0,0,0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"133495","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-08 16:00:18","reservation_modified_date_time":"2021-11-09 02:12:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332401","reservation_id":"124850","confirmation_number":"PB12226305986","room_confirmation_number":"PB12366483367","room_stay_from":"2021-11-06","room_stay_to":"2021-11-08","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"132936","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-11-08 16:36:45","reservation_modified_date_time":"2021-11-08 16:36:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"Reservation created for complete past date","deltaChange":"20.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3218223","reservation_id":"110417","confirmation_number":"PB12274655057","room_confirmation_number":"PB12342698664","room_stay_from":"2021-11-06","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"87086","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-03-18 18:54:22","reservation_modified_date_time":"2021-03-18 18:54:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87086","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3223860","reservation_id":"111498","confirmation_number":"PB12262092353","room_confirmation_number":"PB12393284413","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"118062","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-03-28 13:50:28","reservation_modified_date_time":"2021-03-28 13:50:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118062","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3260471","reservation_id":"114199","confirmation_number":"PB12263590572","room_confirmation_number":"PB12326180287","room_stay_from":"2021-11-08","room_stay_to":"2021-11-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":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"89546","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-30 14:08:32","reservation_modified_date_time":"2021-06-01 16:09:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89546","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330182","reservation_id":"124776","confirmation_number":"PB12214057848","room_confirmation_number":"PB12365229491","room_stay_from":"2021-10-31","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"132844","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-10-26 00:59:06","reservation_modified_date_time":"2021-10-31 20:37:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132844","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330471","reservation_id":"113397","confirmation_number":"PB12287066085","room_confirmation_number":"PB12338578694","room_stay_from":"2021-11-07","room_stay_to":"2021-11-11","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":"119982","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-04-19 17:34:17","reservation_modified_date_time":"2021-11-02 14:41:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119982","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330626","reservation_id":"114062","confirmation_number":"PB12253129323","room_confirmation_number":"PB12336156390","room_stay_from":"2021-11-02","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"67988","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-28 14:22:54","reservation_modified_date_time":"2021-11-02 22:56:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"67988","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330709","reservation_id":"113433","confirmation_number":"PB12218235743","room_confirmation_number":"PB12322414188","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"132469","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-19 22:47:13","reservation_modified_date_time":"2021-11-03 12:39:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120023","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330953","reservation_id":"124599","confirmation_number":"PB12249717479","room_confirmation_number":"PB12331522567","room_stay_from":"2021-11-03","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133142","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-10-19 01:14:09","reservation_modified_date_time":"2021-11-03 21:14:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133142","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330978","reservation_id":"118584","confirmation_number":"PB12286604425","room_confirmation_number":"PB12327425426","room_stay_from":"2021-11-04","room_stay_to":"2021-11-10","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":"125636","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-02 23:43:06","reservation_modified_date_time":"2021-11-03 23:26:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125636","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331000","reservation_id":"123577","confirmation_number":"PB12270959891","room_confirmation_number":"PB12356633135","room_stay_from":"2021-11-03","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"113213","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-24 02:34:37","reservation_modified_date_time":"2021-11-04 00:11:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113213","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331244","reservation_id":"102331","confirmation_number":"PB12215715798","room_confirmation_number":"PB12372784524","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"30198","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-05 21:49:20","reservation_modified_date_time":"2021-11-04 17:46:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"30198","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331258","reservation_id":"125063","confirmation_number":"PB12275936028","room_confirmation_number":"PB12338614823","room_stay_from":"2021-11-06","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"133231","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-04 18:55:50","reservation_modified_date_time":"2021-11-04 18:56:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133231","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331493","reservation_id":"122363","confirmation_number":"PB12227300539","room_confirmation_number":"PB12351801479","room_stay_from":"2021-11-05","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"122316","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-01 19:26:13","reservation_modified_date_time":"2021-11-05 20:19:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122316","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331501","reservation_id":"124833","confirmation_number":"PB12268981809","room_confirmation_number":"PB12390620385","room_stay_from":"2021-11-05","room_stay_to":"2021-11-11","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":"1781","service_quantity":"1","customer_traveller_id":"133285","product_attribute_values":"resort_fee#&#12","reservation_created_date":"2021-10-28 01:05:18","reservation_modified_date_time":"2021-11-05 20:57:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133285","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331571","reservation_id":"125072","confirmation_number":"PB12272643084","room_confirmation_number":"PB12378959924","room_stay_from":"2021-11-06","room_stay_to":"2021-11-19","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","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","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"110752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-05 00:48:13","reservation_modified_date_time":"2021-11-05 23:48:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331820","reservation_id":"125112","confirmation_number":"BV12276073132","room_confirmation_number":"BV12418050266","room_stay_from":"2021-11-06","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"133342","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-06 05:11:55","reservation_modified_date_time":"2021-11-06 21:32:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133342","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"124","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":"5331929","reservation_id":"114027","confirmation_number":"PB12263928392","room_confirmation_number":"PB12357033729","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"133220","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-27 22:27:28","reservation_modified_date_time":"2021-11-07 14:26:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133220","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331989","reservation_id":"124966","confirmation_number":"BV12273316504","room_confirmation_number":"BV12483666991","room_stay_from":"2021-11-01","room_stay_to":"2021-11-12","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"133111","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-02 00:58:54","reservation_modified_date_time":"2021-11-07 16:59:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332051","reservation_id":"125162","confirmation_number":"BP12219182198","room_confirmation_number":"BP12538131363","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133091","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-07 19:43:48","reservation_modified_date_time":"2021-11-07 19:43:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133091","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332083","reservation_id":"125111","confirmation_number":"PB12272729585","room_confirmation_number":"PB12374682600","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133398","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-06 03:54:39","reservation_modified_date_time":"2021-11-07 20:47:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133398","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332090","reservation_id":"124554","confirmation_number":"PB12217739242","room_confirmation_number":"PB12388937820","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"132538","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-10-17 19:15:05","reservation_modified_date_time":"2021-11-07 21:06:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132538","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332104","reservation_id":"125026","confirmation_number":"PB12271352868","room_confirmation_number":"PB12388206836","room_stay_from":"2021-11-05","room_stay_to":"2021-11-09","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":"133186","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-03 23:39:55","reservation_modified_date_time":"2021-11-07 21:28:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332154","reservation_id":"125171","confirmation_number":"PB12253459112","room_confirmation_number":"PB12377248361","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133410","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-07 21:38:15","reservation_modified_date_time":"2021-11-07 22:59:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133410","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332161","reservation_id":"125178","confirmation_number":"PB12268460035","room_confirmation_number":"PB12357246823","room_stay_from":"2021-11-07","room_stay_to":"2021-11-10","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":"107618","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-07 23:29:36","reservation_modified_date_time":"2021-11-07 23:29:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107618","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332212","reservation_id":"125131","confirmation_number":"BV12291685544","room_confirmation_number":"BV12463819150","room_stay_from":"2021-11-07","room_stay_to":"2021-11-11","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":"133346","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-06 23:40:19","reservation_modified_date_time":"2021-11-08 02:09:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133346","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332222","reservation_id":"125182","confirmation_number":"BP12233556123","room_confirmation_number":"BP12540334208","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,12.00","nightly_discount":"0.00,0.00","subtotal":"32.00","grand_total":"36.16","paid_amount":"36.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"133422","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 01:11:40","reservation_modified_date_time":"2021-11-08 02:10:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133422","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332225","reservation_id":"125187","confirmation_number":"BP12254697042","room_confirmation_number":"BP12510427139","room_stay_from":"2021-11-07","room_stay_to":"2021-11-10","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":"133429","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 02:26:25","reservation_modified_date_time":"2021-11-08 02:26:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133429","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332245","reservation_id":"125146","confirmation_number":"PB12287753982","room_confirmation_number":"PB12361115730","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","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":"133372","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-07 16:46:26","reservation_modified_date_time":"2021-11-08 03:59:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133372","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332293","reservation_id":"125198","confirmation_number":"PB12271223883","room_confirmation_number":"PB12318025143","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","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":"133315","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 13:01:33","reservation_modified_date_time":"2021-11-08 13:01:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133315","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332301","reservation_id":"125199","confirmation_number":"BP12297352514","room_confirmation_number":"BP12591302541","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","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":"133440","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 14:05:10","reservation_modified_date_time":"2021-11-08 14:16:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133440","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332346","reservation_id":"125142","confirmation_number":"PB12277081052","room_confirmation_number":"PB12363196475","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,12.00","nightly_discount":"0.00,0.00","subtotal":"32.00","grand_total":"36.16","paid_amount":"36.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"133418","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-07 15:31:09","reservation_modified_date_time":"2021-11-08 15:59:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133418","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332405","reservation_id":"124850","confirmation_number":"PB12271366861","room_confirmation_number":"PB12321631070","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","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":"132936","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 16:36:46","reservation_modified_date_time":"2021-11-08 16:36:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332413","reservation_id":"125190","confirmation_number":"BP12250978993","room_confirmation_number":"BP12595890967","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133448","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 04:03:32","reservation_modified_date_time":"2021-11-08 16:54:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133448","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"125","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":"5332434","reservation_id":"125200","confirmation_number":"BP12218781891","room_confirmation_number":"BP12541551030","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133454","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 14:21:07","reservation_modified_date_time":"2021-11-08 18:06:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133454","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"125","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":"5332453","reservation_id":"125208","confirmation_number":"PB12220660441","room_confirmation_number":"PB12347141882","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133456","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 17:42:29","reservation_modified_date_time":"2021-11-08 18:48:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133456","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332462","reservation_id":"125189","confirmation_number":"BP12268758142","room_confirmation_number":"BP12599094286","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133457","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 04:01:47","reservation_modified_date_time":"2021-11-08 19:25:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133457","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","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":"5332467","reservation_id":"125212","confirmation_number":"BP12212458154","room_confirmation_number":"BP12552471545","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","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":"133459","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 19:37:10","reservation_modified_date_time":"2021-11-08 19:37:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332473","reservation_id":"125176","confirmation_number":"BV12289368321","room_confirmation_number":"BV12497051804","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133411","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-07 23:06:04","reservation_modified_date_time":"2021-11-08 19:41:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133411","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"124","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":"5332515","reservation_id":"125151","confirmation_number":"BP12255058556","room_confirmation_number":"BP12531057852","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133470","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-07 18:27:29","reservation_modified_date_time":"2021-11-08 21:09:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133470","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"125","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":"5332522","reservation_id":"125205","confirmation_number":"BV12230607945","room_confirmation_number":"BV12482628859","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133471","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 17:09:45","reservation_modified_date_time":"2021-11-08 21:12:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133471","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332560","reservation_id":"125216","confirmation_number":"PB12233489271","room_confirmation_number":"PB12347549012","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","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":"1781","service_quantity":"1","customer_traveller_id":"133480","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 20:17:21","reservation_modified_date_time":"2021-11-08 22:26:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133480","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332577","reservation_id":"125203","confirmation_number":"BP12229377501","room_confirmation_number":"BP12580323542","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133484","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 16:17:43","reservation_modified_date_time":"2021-11-09 00:03:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133484","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","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":"5332595","reservation_id":"125186","confirmation_number":"BP12251528075","room_confirmation_number":"BP12581472340","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"20,20,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"52.00","grand_total":"58.76","paid_amount":"58.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"133489","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 02:19:11","reservation_modified_date_time":"2021-11-09 01:12:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133489","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332600","reservation_id":"125226","confirmation_number":"BV12219654868","room_confirmation_number":"BV12433844214","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133492","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 23:13:19","reservation_modified_date_time":"2021-11-09 01:18:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133492","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332616","reservation_id":"125228","confirmation_number":"BV12289103914","room_confirmation_number":"BV12465413494","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133486","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-09 00:08:52","reservation_modified_date_time":"2021-11-09 02:11:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133486","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"124","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":"5332619","reservation_id":"124448","confirmation_number":"PB12293415231","room_confirmation_number":"PB12397050697","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","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":"133495","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-10-14 02:59:13","reservation_modified_date_time":"2021-11-09 02:12:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332625","reservation_id":"124447","confirmation_number":"PB12246918714","room_confirmation_number":"PB12335520266","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","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":"133495","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-10-14 02:59:08","reservation_modified_date_time":"2021-11-09 02:12:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332629","reservation_id":"125231","confirmation_number":"BP12254495702","room_confirmation_number":"BP12573685709","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133496","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-09 01:14:12","reservation_modified_date_time":"2021-11-09 02:56:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133496","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"125","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":"5332402","reservation_id":"124850","confirmation_number":"PB12250319475","room_confirmation_number":"PB12366483367","room_stay_from":"2021-11-06","room_stay_to":"2021-11-08","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":"132936","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-10-28 17:57:11","reservation_modified_date_time":"2021-11-08 16:36:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5332375","reservation_id":"125147","confirmation_number":"BV12248937815","room_confirmation_number":"BV12481775965","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 16:20:02","reservation_modified_date_time":"2021-11-08 16:20:02","customer_id":"133447","parentCustTravId":"133447","customer_traveller_id":"133447","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-07","sub_hotel_id":"124","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5332461","reservation_id":"124833","confirmation_number":"PB12293080422","room_confirmation_number":"PB12390620385","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":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 19:17:45","reservation_modified_date_time":"2021-11-08 19:17:45","customer_id":"133285","parentCustTravId":"133285","customer_traveller_id":"133285","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-05","sub_hotel_id":"123","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5332482","reservation_id":"124850","confirmation_number":"PB12211094413","room_confirmation_number":"PB12321631070","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":"2021-11-08 19:55:54","reservation_modified_date_time":"2021-11-08 19:55:54","customer_id":"132936","parentCustTravId":"132936","customer_traveller_id":"132936","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"123","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":"5332487","reservation_id":"125176","confirmation_number":"BV12282131737","room_confirmation_number":"BV12497051804","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":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 20:06:48","reservation_modified_date_time":"2021-11-08 20:06:48","customer_id":"133411","parentCustTravId":"133411","customer_traveller_id":"133411","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"124","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5332516","reservation_id":"125151","confirmation_number":"BP12213672662","room_confirmation_number":"BP12531057852","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":"2021-11-08 20:44:04","reservation_modified_date_time":"2021-11-08 21:09:57","customer_id":"133470","parentCustTravId":"133470","customer_traveller_id":"133470","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"125","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":"5332546","reservation_id":"125112","confirmation_number":"BV12269784436","room_confirmation_number":"BV12418050266","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":"21.40","paid_amount":"21.40","product_id":"1082","service_quantity":"1","product_name":"Hourly Parking","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 22:10:23","reservation_modified_date_time":"2021-11-08 22:10:23","customer_id":"133342","parentCustTravId":"133342","customer_traveller_id":"133342","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-06","sub_hotel_id":"124","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5332553","reservation_id":"125223","confirmation_number":"PB12298232911","room_confirmation_number":"PB12358549474","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":"45.20","paid_amount":"45.20","product_id":"1082","service_quantity":"2","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 22:19:06","reservation_modified_date_time":"2021-11-08 22:19:06","customer_id":"133476","parentCustTravId":"133476","customer_traveller_id":"133476","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"123","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5331859","reservation_id":"125079","confirmation_number":"PB12224101570","room_confirmation_number":"BP12550955585","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":"2021-11-07 00:08:38","reservation_modified_date_time":"2021-11-07 00:08:38","customer_id":"133315","parentCustTravId":"133315","customer_traveller_id":"133315","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-11-08 14:59:45","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-06","sub_hotel_id":"123","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":"5332521","reservation_id":"125205","confirmation_number":"BV12235607815","room_confirmation_number":"BV12482628859","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"15.00","paid_amount":"15.00","product_id":"1082","service_quantity":"1","product_name":"Upgrade Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 21:04:32","reservation_modified_date_time":"2021-11-08 21:12:26","customer_id":"133471","parentCustTravId":"133471","customer_traveller_id":"133471","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"123","currentDayPrice":"15.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"_taxable":[{"room_stay_id":"5332223","reservation_id":"125182","confirmation_number":"BP12540334208","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"62.99,70.99","nightly_discount":"0.00,0.00","subtotal":"133.98","grand_total":"151.40","paid_amount":"151.40","room_type_id":"294","product_id":"1125","siteminder_id":"","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":"133422","customer_id":"133422","source_of_creation":"Expedia","reservation_created_date":"2021-11-08 01:11:40","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":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"70.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ean_taxable":[{"room_stay_id":"5332517","reservation_id":"125151","confirmation_number":"BP12531057852","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"33.25,33.25","nightly_discount":"0,0","subtotal":"66.50","grand_total":"75.15","paid_amount":"75.15","room_type_id":"293","product_id":"1124","siteminder_id":"EAN-1854434099","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":"133470","customer_id":"133470","source_of_creation":"Expedia","reservation_created_date":"2021-11-07 18:27:29","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"33.25","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":"5332601","reservation_id":"125226","confirmation_number":"BV12433844214","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.98","nightly_discount":"0","subtotal":"69.98","grand_total":"79.08","paid_amount":"79.08","room_type_id":"289","product_id":"1099","siteminder_id":"EAN-1855041647","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133492","customer_id":"133492","source_of_creation":"Expedia","reservation_created_date":"2021-11-08 23:13:19","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"69.98","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"}]}],"htl_taxable":[{"room_stay_id":"5332578","reservation_id":"125203","confirmation_number":"BP12580323542","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"68.24","nightly_discount":"0","subtotal":"68.24","grand_total":"77.11","paid_amount":"77.11","room_type_id":"294","product_id":"1126","siteminder_id":"HTL-1854842255","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133484","customer_id":"133484","source_of_creation":"Expedia","reservation_created_date":"2021-11-08 16:17:43","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"68.24","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":"5332615","reservation_id":"125228","confirmation_number":"BV12465413494","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"95.86,95.86","nightly_discount":"0,0","subtotal":"191.72","grand_total":"216.64","paid_amount":"0.00","room_type_id":"314","product_id":"1229","siteminder_id":"HTL-1855064916","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133486","customer_id":"133486","source_of_creation":"Expedia","reservation_created_date":"2021-11-09 00:08:52","canceled_nights_data":"","product_name":"BV Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"95.86","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"}]}],"ean_non_taxable":[{"room_stay_id":"5332524","reservation_id":"125168","confirmation_number":"BV12485943989","room_stay_from":"2021-11-07","room_stay_to":"2021-11-08","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.98","nightly_discount":"0.00","subtotal":"69.98","grand_total":"79.08","paid_amount":"79.08","room_type_id":"309","product_id":"1226","siteminder_id":"EAN-1854499033","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133400","customer_id":"133400","source_of_creation":"Expedia","reservation_created_date":"2021-11-07 21:25:36","service_canceled_date_time":"2021-11-08 21:17:49","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"79.08","sub_hotel_id":"124","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}]},"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":10,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5330952","reservation_id":"124599","confirmation_number":"PB12331522567","room_stay_from":"2021-11-03","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.27,179.27,212.66,212.66,194.86,194.86,194.86","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1368.44","grand_total":"1546.34","paid_amount":"1546.34","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-3728219191","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":"133142","customer_id":"133142","source_of_creation":"Booking.com","reservation_created_date":"2021-10-19 01:14:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"226.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"194.86","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":"5331494","reservation_id":"122363","confirmation_number":"PB12351801479","room_stay_from":"2021-11-05","room_stay_to":"2021-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"235.06,235.06,215.29,215.29,215.29,215.29,388.5,424.09","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2143.87","grand_total":"2422.57","paid_amount":"2422.57","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-2205139040","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122316","customer_id":"122316","source_of_creation":"Booking.com","reservation_created_date":"2021-09-01 19:26:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"357.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"215.29","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332084","reservation_id":"125111","confirmation_number":"PB12374682600","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.44,222.44","nightly_discount":"0,0","subtotal":"444.88","grand_total":"502.71","paid_amount":"502.71","room_type_id":"287","product_id":"1089","siteminder_id":"BDC-3029207142","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133398","customer_id":"133398","source_of_creation":"Booking.com","reservation_created_date":"2021-11-06 03:54:39","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"72.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"222.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332153","reservation_id":"125171","confirmation_number":"PB12377248361","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"104.92,104.92","nightly_discount":"0,0","subtotal":"209.84","grand_total":"237.12","paid_amount":"237.12","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-3442289660","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133410","customer_id":"133410","source_of_creation":"Booking.com","reservation_created_date":"2021-11-07 21:38:15","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"37.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"104.92","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332345","reservation_id":"125142","confirmation_number":"PB12363196475","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"121.01,129.00","nightly_discount":"0.00,7.55","subtotal":"250.01","grand_total":"273.98","paid_amount":"273.98","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-2473623440","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133418","customer_id":"133418","source_of_creation":"Booking.com","reservation_created_date":"2021-11-07 15:31:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"22.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.00","currentDayDiscount":"7.55","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332454","reservation_id":"125208","confirmation_number":"PB12347141882","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.19","nightly_discount":"0","subtotal":"113.19","grand_total":"127.90","paid_amount":"127.90","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2571014068","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133456","customer_id":"133456","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 17:42:29","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"19.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"113.19","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332523","reservation_id":"125205","confirmation_number":"BV12482628859","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.94","nightly_discount":"0","subtotal":"69.94","grand_total":"79.04","paid_amount":"79.04","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-3252971755","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133471","customer_id":"133471","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 17:09:45","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"16.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"69.94","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":"5332561","reservation_id":"125216","confirmation_number":"PB12347549012","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.46,79.46,79.46,143.03","nightly_discount":"0,0,0,0","subtotal":"381.41","grand_total":"430.99","paid_amount":"430.99","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-2957392964","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133480","customer_id":"133480","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 20:17:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"69.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"79.46","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":"5331001","reservation_id":"123577","confirmation_number":"PB12356633135","room_stay_from":"2021-11-03","room_stay_to":"2021-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"240.57,240.57,262.54,262.54,240.57,240.57,240.57,240.57,433.03,472.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2874.11","grand_total":"3247.75","paid_amount":"3247.75","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1834171790","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":"113213","customer_id":"113213","source_of_creation":"Expedia","reservation_created_date":"2021-09-24 02:34:37","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"240.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331502","reservation_id":"124833","confirmation_number":"PB12390620385","room_stay_from":"2021-11-05","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.61,186.61,170.99,170.99,170.99,170.99","nightly_discount":"0,0,0,0,0,0","subtotal":"1057.18","grand_total":"1194.61","paid_amount":"1194.61","room_type_id":"289","product_id":"1105","siteminder_id":"EXP-1849781981","collect_which":"channel_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":"133285","customer_id":"133285","source_of_creation":"Expedia","reservation_created_date":"2021-10-28 01:05:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"170.99","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":"5332620","reservation_id":"124448","confirmation_number":"PB12397050697","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"298.12,298.12,298.12,536.61","nightly_discount":"0.00,0.00,0.00,60.63","subtotal":"1430.97","grand_total":"1548.48","paid_amount":"1548.48","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1843416807","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":"133495","customer_id":"133495","source_of_creation":"Expedia","reservation_created_date":"2021-10-14 02:59:13","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"298.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332626","reservation_id":"124447","confirmation_number":"PB12335520266","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"298.12,298.12,298.12,536.61","nightly_discount":"0.00,0.00,0.00,62.58","subtotal":"1430.97","grand_total":"1546.28","paid_amount":"1546.28","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1843416805","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133495","customer_id":"133495","source_of_creation":"Expedia","reservation_created_date":"2021-10-14 02:59:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"298.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5330472","reservation_id":"113397","confirmation_number":"PB12338578694","room_stay_from":"2021-11-07","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.38,111.38,111.38,111.38","nightly_discount":"0,0,0,0","subtotal":"445.52","grand_total":"503.44","paid_amount":"503.44","room_type_id":"286","product_id":"1086","siteminder_id":"GAM-R2460587057","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":"119982","customer_id":"119982","source_of_creation":"Getaroom.com","reservation_created_date":"2021-04-19 17:34:17","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"111.38","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":"5330979","reservation_id":"118584","confirmation_number":"PB12327425426","room_stay_from":"2021-11-04","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.80,105.64,105.64,96.80,96.80,96.80","nightly_discount":"0,0,0,0,0,0","subtotal":"598.48","grand_total":"676.28","paid_amount":"676.28","room_type_id":"289","product_id":"1106","siteminder_id":"GAM-R2633475304","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":"125636","customer_id":"125636","source_of_creation":"Getaroom.com","reservation_created_date":"2021-07-02 23:43:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"96.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3223859","reservation_id":"111498","confirmation_number":"PB12393284413","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,140.00,140.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"994.40","paid_amount":"994.40","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":"118062","customer_id":"118062","source_of_creation":"FE","reservation_created_date":"2021-03-28 13:50:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330625","reservation_id":"114062","confirmation_number":"PB12336156390","room_stay_from":"2021-11-02","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,221.00,221.00,201.00,201.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,66.28","subtotal":"1447.00","grand_total":"1560.21","paid_amount":"1560.21","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"67988","customer_id":"67988","source_of_creation":"FE","reservation_created_date":"2021-04-28 14:22:54","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"201.00","currentDayDiscount":"66.28","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330707","reservation_id":"113433","confirmation_number":"PB12322414188","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"162.00,162.00,162.00","nightly_discount":"0.00,0.00,0.00","subtotal":"486.00","grand_total":"549.18","paid_amount":"549.18","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":"120023","customer_id":"120023","source_of_creation":"FE","reservation_created_date":"2021-04-19 22:47:13","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"162.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331931","reservation_id":"114027","confirmation_number":"PB12357033729","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.00,158.00,158.00,138.00,138.00,138.00,138.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,47.58","subtotal":"1006.00","grand_total":"1083.02","paid_amount":"1083.02","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133220","customer_id":"133220","source_of_creation":"FE","reservation_created_date":"2021-04-27 22:27:28","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332160","reservation_id":"125178","confirmation_number":"PB12357246823","room_stay_from":"2021-11-07","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.42,104.42,104.42","nightly_discount":"0.00,0.00,0.00","subtotal":"313.26","grand_total":"353.99","paid_amount":"353.99","room_type_id":"290","product_id":"1113","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107618","customer_id":"107618","source_of_creation":"FE","reservation_created_date":"2021-11-07 23:29:36","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"104.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332211","reservation_id":"125131","confirmation_number":"BV12463819150","room_stay_from":"2021-11-07","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.69,78.69,78.69,78.69","nightly_discount":"0.00,0.00,0.00,13.27","subtotal":"314.76","grand_total":"340.68","paid_amount":"340.68","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133346","customer_id":"133346","source_of_creation":"FE","reservation_created_date":"2021-11-06 23:40:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"78.69","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3218222","reservation_id":"110417","confirmation_number":"PB12342698664","room_stay_from":"2021-11-06","room_stay_to":"2021-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,120.00,120.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"994.40","paid_amount":"994.40","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":"87086","customer_id":"87086","source_of_creation":"PMS","reservation_created_date":"2021-03-18 18:54:22","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3260470","reservation_id":"114199","confirmation_number":"PB12326180287","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,156.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"546.00","grand_total":"616.98","paid_amount":"616.98","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89546","customer_id":"89546","source_of_creation":"PMS","reservation_created_date":"2021-04-30 14:08:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330181","reservation_id":"124776","confirmation_number":"PB12365229491","room_stay_from":"2021-10-31","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.52,186.58,186.58,186.58,186.58,236.60,236.60,202.80,202.80,202.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,97.40","subtotal":"1971.44","grand_total":"2117.66","paid_amount":"2117.66","room_type_id":"289","product_id":"1108","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":"132844","customer_id":"132844","source_of_creation":"PMS","reservation_created_date":"2021-10-26 00:59:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"202.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331245","reservation_id":"102331","confirmation_number":"PB12372784524","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,140.00,140.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"994.40","paid_amount":"994.40","room_type_id":"289","product_id":"1103","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":"30198","customer_id":"30198","source_of_creation":"PMS","reservation_created_date":"2020-11-05 21:49:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331257","reservation_id":"125063","confirmation_number":"PB12338614823","room_stay_from":"2021-11-06","room_stay_to":"2021-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"192.75,132.18,132.18,132.18,132.18,237.90,202.31","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1161.68","grand_total":"1312.70","paid_amount":"1312.70","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":"133231","customer_id":"133231","source_of_creation":"PMS","reservation_created_date":"2021-11-04 18:55: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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"132.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331570","reservation_id":"125072","confirmation_number":"PB12378959924","room_stay_from":"2021-11-06","room_stay_to":"2021-11-19","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"149.99,99.00,99.00,99.00,99.00,99.00,149.99,149.99,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1439.97","grand_total":"1627.17","paid_amount":"1627.17","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110752","customer_id":"110752","source_of_creation":"PMS","reservation_created_date":"2021-11-05 00:48:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332088","reservation_id":"124554","confirmation_number":"PB12388937820","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"236.60,236.60","nightly_discount":"0.00,0.00","subtotal":"473.20","grand_total":"534.71","paid_amount":"534.71","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132538","customer_id":"132538","source_of_creation":"PMS","reservation_created_date":"2021-10-17 19:15:05","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"236.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332103","reservation_id":"125026","confirmation_number":"PB12388206836","room_stay_from":"2021-11-05","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.57,206.51,143.19,143.19","nightly_discount":"0.00,0.00,0.00,0","subtotal":"672.46","grand_total":"759.88","paid_amount":"759.88","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133186","customer_id":"133186","source_of_creation":"PMS","reservation_created_date":"2021-11-03 23:39:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"143.19","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332244","reservation_id":"125146","confirmation_number":"PB12361115730","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.82,188.82","nightly_discount":"0.00,0","subtotal":"377.64","grand_total":"426.73","paid_amount":"426.73","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":"133372","customer_id":"133372","source_of_creation":"PMS","reservation_created_date":"2021-11-07 16:46:26","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"188.82","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332292","reservation_id":"125198","confirmation_number":"PB12318025143","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.09","nightly_discount":"0.00","subtotal":"140.09","grand_total":"158.31","paid_amount":"158.31","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":"133315","customer_id":"133315","source_of_creation":"PMS","reservation_created_date":"2021-11-08 13:01:33","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"140.09","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332403","reservation_id":"124850","confirmation_number":"PB12321631070","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"219.70,219.70","nightly_discount":"0.00,0.00","subtotal":"439.40","grand_total":"496.52","paid_amount":"496.52","room_type_id":"291","product_id":"1119","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":"132936","customer_id":"132936","source_of_creation":"PMS","reservation_created_date":"2021-11-08 16:36:46","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"219.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332552","reservation_id":"125223","confirmation_number":"PB12358549474","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133476","customer_id":"133476","source_of_creation":"PMS","reservation_created_date":"2021-11-08 22:19:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332400","reservation_id":"124850","confirmation_number":"PB12366483367","room_stay_from":"2021-11-06","room_stay_to":"2021-11-08","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"253.50,219.70","nightly_discount":"0.00,0.00","subtotal":"473.20","grand_total":"534.71","paid_amount":"534.71","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132936","customer_id":"132936","source_of_creation":"PMS","reservation_created_date":"2021-10-28 17:57:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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":[{"room_stay_id":"3126090","reservation_id":"87088","confirmation_number":"PB12390189540","room_stay_from":"2021-11-07","room_stay_to":"2021-11-20","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.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","subtotal":"1703.00","grand_total":"1924.39","paid_amount":"148.03","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":"104956","customer_id":"104956","source_of_creation":"PMS","reservation_created_date":"2019-11-13 14:48:29","service_canceled_date_time":"2021-11-08 15:53:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_0","total_paid_amount":"148.03","sub_hotel_id":"123","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5326758","reservation_id":"124554","confirmation_number":"PB12235258106","room_confirmation_number":"PB12388937820","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"132538","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-10-17 19:15:05","reservation_modified_date_time":"2021-10-17 19:15:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132538","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330708","reservation_id":"113433","confirmation_number":"PB12248505976","room_confirmation_number":"PB12322414188","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"120023","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-11-03 12:39:17","reservation_modified_date_time":"2021-11-03 12:39:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120023","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330999","reservation_id":"123577","confirmation_number":"PB12236701275","room_confirmation_number":"PB12356633135","room_stay_from":"2021-11-03","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"113213","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-03 12:39:47","reservation_modified_date_time":"2021-11-04 00:11:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113213","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331492","reservation_id":"122363","confirmation_number":"PB12221640478","room_confirmation_number":"PB12351801479","room_stay_from":"2021-11-05","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,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":"122316","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-09-01 19:26:13","reservation_modified_date_time":"2021-11-05 20:19:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122316","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331566","reservation_id":"125072","confirmation_number":"PB12286905271","room_confirmation_number":"PB12378959924","room_stay_from":"2021-11-06","room_stay_to":"2021-11-19","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"110752","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-05 23:45:22","reservation_modified_date_time":"2021-11-05 23:45:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332339","reservation_id":"125142","confirmation_number":"PB12284669704","room_confirmation_number":"PB12363196475","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"133418","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-11-08 15:57:52","reservation_modified_date_time":"2021-11-08 15:57:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133418","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","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":"5332404","reservation_id":"124850","confirmation_number":"PB12264180373","room_confirmation_number":"PB12321631070","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"132936","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-08 16:36:46","reservation_modified_date_time":"2021-11-08 16:36:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332624","reservation_id":"124447","confirmation_number":"PB12253581217","room_confirmation_number":"PB12335520266","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0,0,0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"133495","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-08 16:00:18","reservation_modified_date_time":"2021-11-09 02:12:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332401","reservation_id":"124850","confirmation_number":"PB12226305986","room_confirmation_number":"PB12366483367","room_stay_from":"2021-11-06","room_stay_to":"2021-11-08","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"132936","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-11-08 16:36:45","reservation_modified_date_time":"2021-11-08 16:36:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"Reservation created for complete past date","deltaChange":"20.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3218223","reservation_id":"110417","confirmation_number":"PB12274655057","room_confirmation_number":"PB12342698664","room_stay_from":"2021-11-06","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"87086","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-03-18 18:54:22","reservation_modified_date_time":"2021-03-18 18:54:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87086","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3223860","reservation_id":"111498","confirmation_number":"PB12262092353","room_confirmation_number":"PB12393284413","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"118062","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-03-28 13:50:28","reservation_modified_date_time":"2021-03-28 13:50:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118062","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3260471","reservation_id":"114199","confirmation_number":"PB12263590572","room_confirmation_number":"PB12326180287","room_stay_from":"2021-11-08","room_stay_to":"2021-11-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":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"89546","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-30 14:08:32","reservation_modified_date_time":"2021-06-01 16:09:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89546","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330182","reservation_id":"124776","confirmation_number":"PB12214057848","room_confirmation_number":"PB12365229491","room_stay_from":"2021-10-31","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"132844","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-10-26 00:59:06","reservation_modified_date_time":"2021-10-31 20:37:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132844","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330471","reservation_id":"113397","confirmation_number":"PB12287066085","room_confirmation_number":"PB12338578694","room_stay_from":"2021-11-07","room_stay_to":"2021-11-11","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":"119982","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-04-19 17:34:17","reservation_modified_date_time":"2021-11-02 14:41:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119982","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330626","reservation_id":"114062","confirmation_number":"PB12253129323","room_confirmation_number":"PB12336156390","room_stay_from":"2021-11-02","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"67988","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-28 14:22:54","reservation_modified_date_time":"2021-11-02 22:56:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"67988","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330709","reservation_id":"113433","confirmation_number":"PB12218235743","room_confirmation_number":"PB12322414188","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"132469","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-19 22:47:13","reservation_modified_date_time":"2021-11-03 12:39:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120023","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330953","reservation_id":"124599","confirmation_number":"PB12249717479","room_confirmation_number":"PB12331522567","room_stay_from":"2021-11-03","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133142","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-10-19 01:14:09","reservation_modified_date_time":"2021-11-03 21:14:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133142","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330978","reservation_id":"118584","confirmation_number":"PB12286604425","room_confirmation_number":"PB12327425426","room_stay_from":"2021-11-04","room_stay_to":"2021-11-10","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":"125636","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-02 23:43:06","reservation_modified_date_time":"2021-11-03 23:26:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125636","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331000","reservation_id":"123577","confirmation_number":"PB12270959891","room_confirmation_number":"PB12356633135","room_stay_from":"2021-11-03","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"113213","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-24 02:34:37","reservation_modified_date_time":"2021-11-04 00:11:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113213","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331244","reservation_id":"102331","confirmation_number":"PB12215715798","room_confirmation_number":"PB12372784524","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"30198","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-05 21:49:20","reservation_modified_date_time":"2021-11-04 17:46:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"30198","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331258","reservation_id":"125063","confirmation_number":"PB12275936028","room_confirmation_number":"PB12338614823","room_stay_from":"2021-11-06","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"133231","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-04 18:55:50","reservation_modified_date_time":"2021-11-04 18:56:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133231","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331493","reservation_id":"122363","confirmation_number":"PB12227300539","room_confirmation_number":"PB12351801479","room_stay_from":"2021-11-05","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"122316","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-01 19:26:13","reservation_modified_date_time":"2021-11-05 20:19:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122316","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331501","reservation_id":"124833","confirmation_number":"PB12268981809","room_confirmation_number":"PB12390620385","room_stay_from":"2021-11-05","room_stay_to":"2021-11-11","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":"1781","service_quantity":"1","customer_traveller_id":"133285","product_attribute_values":"resort_fee#&#12","reservation_created_date":"2021-10-28 01:05:18","reservation_modified_date_time":"2021-11-05 20:57:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133285","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331571","reservation_id":"125072","confirmation_number":"PB12272643084","room_confirmation_number":"PB12378959924","room_stay_from":"2021-11-06","room_stay_to":"2021-11-19","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","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","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"110752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-05 00:48:13","reservation_modified_date_time":"2021-11-05 23:48:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331929","reservation_id":"114027","confirmation_number":"PB12263928392","room_confirmation_number":"PB12357033729","room_stay_from":"2021-11-04","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"133220","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-27 22:27:28","reservation_modified_date_time":"2021-11-07 14:26:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133220","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332083","reservation_id":"125111","confirmation_number":"PB12272729585","room_confirmation_number":"PB12374682600","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133398","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-06 03:54:39","reservation_modified_date_time":"2021-11-07 20:47:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133398","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332090","reservation_id":"124554","confirmation_number":"PB12217739242","room_confirmation_number":"PB12388937820","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"132538","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-10-17 19:15:05","reservation_modified_date_time":"2021-11-07 21:06:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132538","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332104","reservation_id":"125026","confirmation_number":"PB12271352868","room_confirmation_number":"PB12388206836","room_stay_from":"2021-11-05","room_stay_to":"2021-11-09","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":"133186","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-03 23:39:55","reservation_modified_date_time":"2021-11-07 21:28:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332154","reservation_id":"125171","confirmation_number":"PB12253459112","room_confirmation_number":"PB12377248361","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133410","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-07 21:38:15","reservation_modified_date_time":"2021-11-07 22:59:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133410","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332161","reservation_id":"125178","confirmation_number":"PB12268460035","room_confirmation_number":"PB12357246823","room_stay_from":"2021-11-07","room_stay_to":"2021-11-10","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":"107618","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-07 23:29:36","reservation_modified_date_time":"2021-11-07 23:29:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107618","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332212","reservation_id":"125131","confirmation_number":"BV12291685544","room_confirmation_number":"BV12463819150","room_stay_from":"2021-11-07","room_stay_to":"2021-11-11","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":"133346","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-06 23:40:19","reservation_modified_date_time":"2021-11-08 02:09:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133346","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332245","reservation_id":"125146","confirmation_number":"PB12287753982","room_confirmation_number":"PB12361115730","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","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":"133372","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-07 16:46:26","reservation_modified_date_time":"2021-11-08 03:59:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133372","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332293","reservation_id":"125198","confirmation_number":"PB12271223883","room_confirmation_number":"PB12318025143","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","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":"133315","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 13:01:33","reservation_modified_date_time":"2021-11-08 13:01:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133315","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332346","reservation_id":"125142","confirmation_number":"PB12277081052","room_confirmation_number":"PB12363196475","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,12.00","nightly_discount":"0.00,0.00","subtotal":"32.00","grand_total":"36.16","paid_amount":"36.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"133418","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-07 15:31:09","reservation_modified_date_time":"2021-11-08 15:59:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133418","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332405","reservation_id":"124850","confirmation_number":"PB12271366861","room_confirmation_number":"PB12321631070","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","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":"132936","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 16:36:46","reservation_modified_date_time":"2021-11-08 16:36:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332453","reservation_id":"125208","confirmation_number":"PB12220660441","room_confirmation_number":"PB12347141882","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133456","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 17:42:29","reservation_modified_date_time":"2021-11-08 18:48:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133456","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332522","reservation_id":"125205","confirmation_number":"BV12230607945","room_confirmation_number":"BV12482628859","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133471","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 17:09:45","reservation_modified_date_time":"2021-11-08 21:12:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133471","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332560","reservation_id":"125216","confirmation_number":"PB12233489271","room_confirmation_number":"PB12347549012","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","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":"1781","service_quantity":"1","customer_traveller_id":"133480","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 20:17:21","reservation_modified_date_time":"2021-11-08 22:26:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133480","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332600","reservation_id":"125226","confirmation_number":"BV12219654868","room_confirmation_number":"BV12433844214","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133492","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 23:13:19","reservation_modified_date_time":"2021-11-09 01:18:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133492","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332619","reservation_id":"124448","confirmation_number":"PB12293415231","room_confirmation_number":"PB12397050697","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","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":"133495","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-10-14 02:59:13","reservation_modified_date_time":"2021-11-09 02:12:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332625","reservation_id":"124447","confirmation_number":"PB12246918714","room_confirmation_number":"PB12335520266","room_stay_from":"2021-11-08","room_stay_to":"2021-11-12","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":"133495","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-10-14 02:59:08","reservation_modified_date_time":"2021-11-09 02:12:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332402","reservation_id":"124850","confirmation_number":"PB12250319475","room_confirmation_number":"PB12366483367","room_stay_from":"2021-11-06","room_stay_to":"2021-11-08","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":"132936","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-10-28 17:57:11","reservation_modified_date_time":"2021-11-08 16:36:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5332461","reservation_id":"124833","confirmation_number":"PB12293080422","room_confirmation_number":"PB12390620385","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":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 19:17:45","reservation_modified_date_time":"2021-11-08 19:17:45","customer_id":"133285","parentCustTravId":"133285","customer_traveller_id":"133285","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-05","sub_hotel_id":"123","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5332482","reservation_id":"124850","confirmation_number":"PB12211094413","room_confirmation_number":"PB12321631070","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":"2021-11-08 19:55:54","reservation_modified_date_time":"2021-11-08 19:55:54","customer_id":"132936","parentCustTravId":"132936","customer_traveller_id":"132936","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"123","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":"5332553","reservation_id":"125223","confirmation_number":"PB12298232911","room_confirmation_number":"PB12358549474","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":"45.20","paid_amount":"45.20","product_id":"1082","service_quantity":"2","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 22:19:06","reservation_modified_date_time":"2021-11-08 22:19:06","customer_id":"133476","parentCustTravId":"133476","customer_traveller_id":"133476","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"123","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5331859","reservation_id":"125079","confirmation_number":"PB12224101570","room_confirmation_number":"BP12550955585","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":"2021-11-07 00:08:38","reservation_modified_date_time":"2021-11-07 00:08:38","customer_id":"133315","parentCustTravId":"133315","customer_traveller_id":"133315","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-11-08 14:59:45","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-06","sub_hotel_id":"123","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":"5332521","reservation_id":"125205","confirmation_number":"BV12235607815","room_confirmation_number":"BV12482628859","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"15.00","paid_amount":"15.00","product_id":"1082","service_quantity":"1","product_name":"Upgrade Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 21:04:32","reservation_modified_date_time":"2021-11-08 21:12:26","customer_id":"133471","parentCustTravId":"133471","customer_traveller_id":"133471","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"123","currentDayPrice":"15.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"_taxable":[],"ean_taxable":[{"room_stay_id":"5332601","reservation_id":"125226","confirmation_number":"BV12433844214","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.98","nightly_discount":"0","subtotal":"69.98","grand_total":"79.08","paid_amount":"79.08","room_type_id":"289","product_id":"1099","siteminder_id":"EAN-1855041647","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133492","customer_id":"133492","source_of_creation":"Expedia","reservation_created_date":"2021-11-08 23:13:19","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"69.98","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"}]}],"htl_taxable":[],"ean_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":6,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5332472","reservation_id":"125176","confirmation_number":"BV12497051804","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"77.71","nightly_discount":"0","subtotal":"77.71","grand_total":"87.81","paid_amount":"87.81","room_type_id":"304","product_id":"1218","siteminder_id":"BDC-3907744020","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133411","customer_id":"133411","source_of_creation":"Booking.com","reservation_created_date":"2021-11-07 23:06:04","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"17.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"77.71","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":"5331821","reservation_id":"125112","confirmation_number":"BV12418050266","room_stay_from":"2021-11-06","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.23,88.36,88.36","nightly_discount":"0,0,0","subtotal":"292.95","grand_total":"331.04","paid_amount":"331.04","room_type_id":"305","product_id":"1222","siteminder_id":"EXP-1853915729","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":"133342","customer_id":"133342","source_of_creation":"Expedia","reservation_created_date":"2021-11-06 05:11:55","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":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"88.36","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":[],"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":"5331988","reservation_id":"124966","confirmation_number":"BV12483666991","room_stay_from":"2021-11-01","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.56,61.56,61.56,61.56,110.00,115.00,80.00,80.00,80.00,80.00,95.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,16.36,0.00,0.00,0.00,0.00,0.00","subtotal":"886.24","grand_total":"982.96","paid_amount":"982.96","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133111","customer_id":"133111","source_of_creation":"PMS","reservation_created_date":"2021-11-02 00:58:54","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5331820","reservation_id":"125112","confirmation_number":"BV12276073132","room_confirmation_number":"BV12418050266","room_stay_from":"2021-11-06","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"133342","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-06 05:11:55","reservation_modified_date_time":"2021-11-06 21:32:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133342","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"124","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":"5331989","reservation_id":"124966","confirmation_number":"BV12273316504","room_confirmation_number":"BV12483666991","room_stay_from":"2021-11-01","room_stay_to":"2021-11-12","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"133111","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-02 00:58:54","reservation_modified_date_time":"2021-11-07 16:59:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332473","reservation_id":"125176","confirmation_number":"BV12289368321","room_confirmation_number":"BV12497051804","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133411","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-07 23:06:04","reservation_modified_date_time":"2021-11-08 19:41:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133411","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"124","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":"5332616","reservation_id":"125228","confirmation_number":"BV12289103914","room_confirmation_number":"BV12465413494","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133486","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-09 00:08:52","reservation_modified_date_time":"2021-11-09 02:11:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133486","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"124","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5332375","reservation_id":"125147","confirmation_number":"BV12248937815","room_confirmation_number":"BV12481775965","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 16:20:02","reservation_modified_date_time":"2021-11-08 16:20:02","customer_id":"133447","parentCustTravId":"133447","customer_traveller_id":"133447","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-07","sub_hotel_id":"124","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5332487","reservation_id":"125176","confirmation_number":"BV12282131737","room_confirmation_number":"BV12497051804","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":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 20:06:48","reservation_modified_date_time":"2021-11-08 20:06:48","customer_id":"133411","parentCustTravId":"133411","customer_traveller_id":"133411","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"124","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5332546","reservation_id":"125112","confirmation_number":"BV12269784436","room_confirmation_number":"BV12418050266","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":"21.40","paid_amount":"21.40","product_id":"1082","service_quantity":"1","product_name":"Hourly Parking","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-08 22:10:23","reservation_modified_date_time":"2021-11-08 22:10:23","customer_id":"133342","parentCustTravId":"133342","customer_traveller_id":"133342","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-06","sub_hotel_id":"124","currentDayPrice":"20.00","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":[],"_taxable":[],"ean_taxable":[],"htl_taxable":[{"room_stay_id":"5332615","reservation_id":"125228","confirmation_number":"BV12465413494","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"95.86,95.86","nightly_discount":"0,0","subtotal":"191.72","grand_total":"216.64","paid_amount":"0.00","room_type_id":"314","product_id":"1229","siteminder_id":"HTL-1855064916","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133486","customer_id":"133486","source_of_creation":"Expedia","reservation_created_date":"2021-11-09 00:08:52","canceled_nights_data":"","product_name":"BV Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"95.86","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"}]}],"ean_non_taxable":[{"room_stay_id":"5332524","reservation_id":"125168","confirmation_number":"BV12485943989","room_stay_from":"2021-11-07","room_stay_to":"2021-11-08","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.98","nightly_discount":"0.00","subtotal":"69.98","grand_total":"79.08","paid_amount":"79.08","room_type_id":"309","product_id":"1226","siteminder_id":"EAN-1854499033","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133400","customer_id":"133400","source_of_creation":"Expedia","reservation_created_date":"2021-11-07 21:25:36","service_canceled_date_time":"2021-11-08 21:17:49","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"79.08","sub_hotel_id":"124","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":8,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5332414","reservation_id":"125190","confirmation_number":"BP12595890967","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"86.87,86.87","nightly_discount":"0,0","subtotal":"173.74","grand_total":"196.32","paid_amount":"196.32","room_type_id":"302","product_id":"1138","siteminder_id":"BDC-2180317338","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":"133448","customer_id":"133448","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 04:03:32","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"52.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"86.87","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":"5332435","reservation_id":"125200","confirmation_number":"BP12541551030","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.45,80.45","nightly_discount":"0,0","subtotal":"160.90","grand_total":"181.81","paid_amount":"181.81","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-2476164757","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133454","customer_id":"133454","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 14:21:07","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","ota_service_fee_amount":"0","commision_charges":"36.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"80.45","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":"5332594","reservation_id":"125186","confirmation_number":"BP12581472340","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.35,60.35,70.00","nightly_discount":"0.00,0.00,0.00","subtotal":"190.70","grand_total":"215.49","paid_amount":"215.49","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-2473639284","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133489","customer_id":"133489","source_of_creation":"Booking.com","reservation_created_date":"2021-11-08 02:19:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"28.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"60.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332630","reservation_id":"125231","confirmation_number":"BP12573685709","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.84,92.84","nightly_discount":"0,0","subtotal":"185.68","grand_total":"209.82","paid_amount":"209.82","room_type_id":"300","product_id":"1135","siteminder_id":"BDC-3787077290","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133496","customer_id":"133496","source_of_creation":"Booking.com","reservation_created_date":"2021-11-09 01:14:12","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"40.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"92.84","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":"5332463","reservation_id":"125189","confirmation_number":"BP12599094286","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"43.25","nightly_discount":"0","subtotal":"43.25","grand_total":"48.88","paid_amount":"48.88","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1854640203","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133457","customer_id":"133457","source_of_creation":"Expedia","reservation_created_date":"2021-11-08 04:01:47","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"43.25","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":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5332050","reservation_id":"125162","confirmation_number":"BP12538131363","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.09,76.09","nightly_discount":"0.00,0.00","subtotal":"152.18","grand_total":"171.96","paid_amount":"85.99","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133091","customer_id":"133091","source_of_creation":"FE","reservation_created_date":"2021-11-07 19:43:48","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"76.09","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5332224","reservation_id":"125187","confirmation_number":"BP12510427139","room_stay_from":"2021-11-07","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00","subtotal":"300.00","grand_total":"339.00","paid_amount":"339.00","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":"133429","customer_id":"133429","source_of_creation":"PMS","reservation_created_date":"2021-11-08 02:26:25","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332302","reservation_id":"125199","confirmation_number":"BP12591302541","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.00","nightly_discount":"0.00","subtotal":"71.00","grand_total":"80.23","paid_amount":"80.23","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":"133440","customer_id":"133440","source_of_creation":"PMS","reservation_created_date":"2021-11-08 14:05:10","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":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"71.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332466","reservation_id":"125212","confirmation_number":"BP12552471545","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","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":"133459","customer_id":"133459","source_of_creation":"PMS","reservation_created_date":"2021-11-08 19:37:10","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":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5332412","reservation_id":"125190","confirmation_number":"BP12241258217","room_confirmation_number":"BP12595890967","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"40,40","nightly_discount":"0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"133448","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-11-08 08:20:57","reservation_modified_date_time":"2021-11-08 16:54:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133448","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"125","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":"5332514","reservation_id":"125151","confirmation_number":"BP12215702909","room_confirmation_number":"BP12531057852","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"133470","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-11-07 18:27:29","reservation_modified_date_time":"2021-11-08 21:09:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133470","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"125","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5332051","reservation_id":"125162","confirmation_number":"BP12219182198","room_confirmation_number":"BP12538131363","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133091","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-07 19:43:48","reservation_modified_date_time":"2021-11-07 19:43:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133091","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332222","reservation_id":"125182","confirmation_number":"BP12233556123","room_confirmation_number":"BP12540334208","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20,12.00","nightly_discount":"0.00,0.00","subtotal":"32.00","grand_total":"36.16","paid_amount":"36.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"133422","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 01:11:40","reservation_modified_date_time":"2021-11-08 02:10:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133422","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332225","reservation_id":"125187","confirmation_number":"BP12254697042","room_confirmation_number":"BP12510427139","room_stay_from":"2021-11-07","room_stay_to":"2021-11-10","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":"133429","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 02:26:25","reservation_modified_date_time":"2021-11-08 02:26:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133429","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332301","reservation_id":"125199","confirmation_number":"BP12297352514","room_confirmation_number":"BP12591302541","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","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":"133440","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 14:05:10","reservation_modified_date_time":"2021-11-08 14:16:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133440","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332413","reservation_id":"125190","confirmation_number":"BP12250978993","room_confirmation_number":"BP12595890967","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133448","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 04:03:32","reservation_modified_date_time":"2021-11-08 16:54:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133448","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"125","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":"5332434","reservation_id":"125200","confirmation_number":"BP12218781891","room_confirmation_number":"BP12541551030","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133454","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 14:21:07","reservation_modified_date_time":"2021-11-08 18:06:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133454","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"125","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":"5332462","reservation_id":"125189","confirmation_number":"BP12268758142","room_confirmation_number":"BP12599094286","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133457","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 04:01:47","reservation_modified_date_time":"2021-11-08 19:25:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133457","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","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":"5332467","reservation_id":"125212","confirmation_number":"BP12212458154","room_confirmation_number":"BP12552471545","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","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":"133459","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-08 19:37:10","reservation_modified_date_time":"2021-11-08 19:37:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5332515","reservation_id":"125151","confirmation_number":"BP12255058556","room_confirmation_number":"BP12531057852","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133470","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-07 18:27:29","reservation_modified_date_time":"2021-11-08 21:09:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133470","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"125","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":"5332577","reservation_id":"125203","confirmation_number":"BP12229377501","room_confirmation_number":"BP12580323542","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133484","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 16:17:43","reservation_modified_date_time":"2021-11-09 00:03:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133484","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","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":"5332595","reservation_id":"125186","confirmation_number":"BP12251528075","room_confirmation_number":"BP12581472340","room_stay_from":"2021-11-08","room_stay_to":"2021-11-11","room_stay_status":"Active","nightly_price":"20,20,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"52.00","grand_total":"58.76","paid_amount":"58.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"133489","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-08 02:19:11","reservation_modified_date_time":"2021-11-09 01:12:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133489","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5332629","reservation_id":"125231","confirmation_number":"BP12254495702","room_confirmation_number":"BP12573685709","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133496","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-09 01:14:12","reservation_modified_date_time":"2021-11-09 02:56:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133496","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"125","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5332516","reservation_id":"125151","confirmation_number":"BP12213672662","room_confirmation_number":"BP12531057852","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":"2021-11-08 20:44:04","reservation_modified_date_time":"2021-11-08 21:09:57","customer_id":"133470","parentCustTravId":"133470","customer_traveller_id":"133470","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-08","sub_hotel_id":"125","currentDayPrice":"28.05","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":[],"_taxable":[{"room_stay_id":"5332223","reservation_id":"125182","confirmation_number":"BP12540334208","room_stay_from":"2021-11-07","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"62.99,70.99","nightly_discount":"0.00,0.00","subtotal":"133.98","grand_total":"151.40","paid_amount":"151.40","room_type_id":"294","product_id":"1125","siteminder_id":"","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":"133422","customer_id":"133422","source_of_creation":"Expedia","reservation_created_date":"2021-11-08 01:11:40","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":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"70.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ean_taxable":[{"room_stay_id":"5332517","reservation_id":"125151","confirmation_number":"BP12531057852","room_stay_from":"2021-11-08","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"33.25,33.25","nightly_discount":"0,0","subtotal":"66.50","grand_total":"75.15","paid_amount":"75.15","room_type_id":"293","product_id":"1124","siteminder_id":"EAN-1854434099","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":"133470","customer_id":"133470","source_of_creation":"Expedia","reservation_created_date":"2021-11-07 18:27:29","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"33.25","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"}]}],"htl_taxable":[{"room_stay_id":"5332578","reservation_id":"125203","confirmation_number":"BP12580323542","room_stay_from":"2021-11-08","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"68.24","nightly_discount":"0","subtotal":"68.24","grand_total":"77.11","paid_amount":"77.11","room_type_id":"294","product_id":"1126","siteminder_id":"HTL-1854842255","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133484","customer_id":"133484","source_of_creation":"Expedia","reservation_created_date":"2021-11-08 16:17:43","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"68.24","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"}]}],"ean_non_taxable":[]}}}