{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-09","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,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":13,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1096,1092,1098,1084","block_room_bookings":[{"confirmation_number":"PB12297425017","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","bundle_room":"0"},{"confirmation_number":"PB12290559301","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","bundle_room":"0"},{"confirmation_number":"PB12229238888","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","bundle_room":"0"},{"confirmation_number":"PB12217614016","room_stay_from":"2020-01-06","room_stay_to":"2020-01-09","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3042913","reservation_id":"87658","confirmation_number":"PB12321592123","room_stay_from":"2020-01-01","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,172.80,172.80,160.80,160.80,160.80,160.80,160.80","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1471.20","grand_total":"1662.45","paid_amount":"1662.45","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-3400601347","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":"95729","customer_id":"95729","source_of_creation":"Booking.com","reservation_created_date":"2019-11-30 02:46:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"110.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.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"}]},{"room_stay_id":"3055483","reservation_id":"88836","confirmation_number":"BP12558992398","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.12,83.85","nightly_discount":"0,0.00","subtotal":"166.97","grand_total":"188.68","paid_amount":"188.68","room_type_id":"298","product_id":"1133","siteminder_id":"BDC-3898643323","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":"95586","customer_id":"95586","source_of_creation":"Booking.com","reservation_created_date":"2019-12-28 15:02:05","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"14.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042518","reservation_id":"87630","confirmation_number":"BP12552858762","room_stay_from":"2020-01-07","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.75,118.75,118.75,130.45,130.45","nightly_discount":"0,0,0,0,0","subtotal":"617.15","grand_total":"697.38","paid_amount":"697.38","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-2182499427","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":"94124","customer_id":"95507","source_of_creation":"Booking.com","reservation_created_date":"2019-11-29 19:12:10","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"92.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.75","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":"3042918","reservation_id":"77288","confirmation_number":"PB12329998445","room_stay_from":"2020-01-08","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.20,174.20,187.20,187.20,174.20,174.20,174.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1245.40","grand_total":"1407.30","paid_amount":"1407.30","room_type_id":"291","product_id":"1117","siteminder_id":"BDC-3043400641","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":"95553","customer_id":"95553","source_of_creation":"Booking.com","reservation_created_date":"2019-05-25 00:32:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"186.81","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3046149","reservation_id":"88170","confirmation_number":"BP12533348084","room_stay_from":"2019-12-29","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.09,97.09,97.09,97.38,97.38,106.97,106.97,97.38,97.38,97.38,97.38,97.38","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1186.87","grand_total":"1341.16","paid_amount":"1341.16","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1389938151","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":"94493","customer_id":"94493","source_of_creation":"Expedia","reservation_created_date":"2019-12-11 19:32:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.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":"3049744","reservation_id":"88605","confirmation_number":"PB12375655650","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.27,73.27,73.27,73.27","nightly_discount":"0,0,0,0","subtotal":"293.08","grand_total":"331.18","paid_amount":"331.18","room_type_id":"292","product_id":"1120","siteminder_id":"EXP-1611617683","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":"95730","customer_id":"95730","source_of_creation":"Expedia","reservation_created_date":"2019-12-23 17:32:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.27","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":"3056316","reservation_id":"89390","confirmation_number":"PB12315225265","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.16,75.16,75.16,75.16","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"300.64","grand_total":"339.72","paid_amount":"339.72","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1617705611","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":"95436","customer_id":"95436","source_of_creation":"Expedia","reservation_created_date":"2020-01-05 16:42:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054682","reservation_id":"89444","confirmation_number":"PB12384968944","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.83,132.83,154.32","nightly_discount":"0,0,0","subtotal":"419.98","grand_total":"474.58","paid_amount":"474.58","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1617989080","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":"95558","customer_id":"95558","source_of_creation":"Expedia","reservation_created_date":"2020-01-06 03:47:09","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.83","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":"3055203","reservation_id":"89546","confirmation_number":"PB12332484135","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.92,106.92,127.63","nightly_discount":"0,0,0","subtotal":"341.47","grand_total":"385.86","paid_amount":"385.86","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1619158642","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":"95562","customer_id":"95562","source_of_creation":"Expedia","reservation_created_date":"2020-01-08 02:57:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.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":"3050976","reservation_id":"88753","confirmation_number":"PB12358870664","room_stay_from":"2020-01-07","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.84,92.84,92.84,99.77,99.77,92.84","nightly_discount":"0,0,0,0,0,0","subtotal":"570.90","grand_total":"645.11","paid_amount":"645.11","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1613050626","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":"95517","customer_id":"95518","source_of_creation":"Expedia","reservation_created_date":"2019-12-27 03:47:08","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":"","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"}]},{"room_stay_id":"3046221","reservation_id":"88186","confirmation_number":"PB12327566106","room_stay_from":"2020-01-08","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.56,128.56,138.15,138.15,128.56,128.56","nightly_discount":"0,0,0,0,0,0","subtotal":"790.54","grand_total":"893.31","paid_amount":"893.31","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1606444384","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":"95574","customer_id":"95574","source_of_creation":"Expedia","reservation_created_date":"2019-12-12 02:12:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.56","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":[{"room_stay_id":"3056115","reservation_id":"89674","confirmation_number":"BV12462016364","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.60","nightly_discount":"0","subtotal":"48.60","grand_total":"54.92","paid_amount":"54.92","room_type_id":"303","product_id":"1139","siteminder_id":"HWR-301584988","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":"95727","customer_id":"95727","source_of_creation":"Hotwire","reservation_created_date":"2020-01-10 00:06:06","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.60","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":"3056117","reservation_id":"89675","confirmation_number":"BP12523452859","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.60","nightly_discount":"0","subtotal":"48.60","grand_total":"54.92","paid_amount":"54.92","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-301586478","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":"95663","customer_id":"95663","source_of_creation":"Hotwire","reservation_created_date":"2020-01-10 00:13:06","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.60","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"}]}],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3055275","reservation_id":"89561","confirmation_number":"BV12482526507","room_stay_from":"2020-01-08","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.63,92.63,115.47,115.47","nightly_discount":"0,0,0,0","subtotal":"416.20","grand_total":"470.30","paid_amount":"470.30","room_type_id":"304","product_id":"1218","siteminder_id":"GCC-0005100055-a6c","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":"95545","customer_id":"95545","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-01-08 15:46:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.63","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3052875","reservation_id":"89107","confirmation_number":"PB12346315732","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.38,84.38,84.38","nightly_discount":"0,0,0","subtotal":"253.14","grand_total":"286.05","paid_amount":"286.05","room_type_id":"286","product_id":"1086","siteminder_id":"AGO-300324026","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":"95526","customer_id":"95526","source_of_creation":"Agoda","reservation_created_date":"2020-01-02 02:27:09","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":"","currentDayPrice":"84.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":"3053193","reservation_id":"89164","confirmation_number":"PB12334473304","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.79","nightly_discount":"0","subtotal":"71.79","grand_total":"81.13","paid_amount":"81.13","room_type_id":"289","product_id":"1093","siteminder_id":"AGO-300490674","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":"95654","customer_id":"95654","source_of_creation":"Agoda","reservation_created_date":"2020-01-02 23:09:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.79","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":"3054711","reservation_id":"88825","confirmation_number":"PB12335025083","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.71,74.71","nightly_discount":"0,0","subtotal":"149.42","grand_total":"168.85","paid_amount":"168.85","room_type_id":"285","product_id":"1083","siteminder_id":"AGO-299338594","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":"95546","customer_id":"95546","source_of_creation":"Agoda","reservation_created_date":"2019-12-28 03:27:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.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":"3055120","reservation_id":"89472","confirmation_number":"PB12335579073","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"71.79,71.79","nightly_discount":"0,0","subtotal":"143.58","grand_total":"162.24","paid_amount":"162.24","room_type_id":"289","product_id":"1121","siteminder_id":"AGO-301289098","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95566","customer_id":"95566","source_of_creation":"Agoda","reservation_created_date":"2020-01-06 22:15:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.79","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":"3055128","reservation_id":"89472","confirmation_number":"PB12347672469","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"71.79,71.79","nightly_discount":"0,0","subtotal":"143.58","grand_total":"162.24","paid_amount":"162.24","room_type_id":"289","product_id":"1123","siteminder_id":"AGO-301289098","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95566","customer_id":"95566","source_of_creation":"Agoda","reservation_created_date":"2020-01-06 22:15:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.79","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":"3055608","reservation_id":"89622","confirmation_number":"PB12341794358","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.21","nightly_discount":"0","subtotal":"67.21","grand_total":"75.94","paid_amount":"75.94","room_type_id":"290","product_id":"1113","siteminder_id":"AGO-301768490","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":"95628","customer_id":"95628","source_of_creation":"Agoda","reservation_created_date":"2020-01-09 05:21:11","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.21","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":"3055775","reservation_id":"89639","confirmation_number":"BV12459968136","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.51","nightly_discount":"0","subtotal":"67.51","grand_total":"76.29","paid_amount":"76.29","room_type_id":"307","product_id":"1224","siteminder_id":"AGO-301824354","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":"95627","customer_id":"95627","source_of_creation":"Agoda","reservation_created_date":"2020-01-09 16:34:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.51","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3050185","reservation_id":"88673","confirmation_number":"PB12386323103","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.50,136.50,136.50","nightly_discount":"0.00,0.00,0.00","subtotal":"409.50","grand_total":"462.74","paid_amount":"462.74","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94848","customer_id":"94848","source_of_creation":"FE","reservation_created_date":"2019-12-25 11:37:11","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055345","reservation_id":"88960","confirmation_number":"PB12310527525","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.35,90.35,90.35,90.35","nightly_discount":"0.00,0.00,0.00,16.39,0.00","subtotal":"361.40","grand_total":"389.86","paid_amount":"389.86","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":"95043","customer_id":"95043","source_of_creation":"FE","reservation_created_date":"2019-12-30 15:30:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.35","currentDayDiscount":"16.39","productIsTaxExempt":false,"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":"3053580","reservation_id":"88468","confirmation_number":"PB12333773046","room_stay_from":"2020-01-03","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,32.74,0.00","subtotal":"623.00","grand_total":"667.00","paid_amount":"667.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":"91746","customer_id":"91746","source_of_creation":"PMS","reservation_created_date":"2019-12-19 15:30:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.00","currentDayDiscount":"32.74","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055937","reservation_id":"89653","confirmation_number":"PB12335013153","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.50","nightly_discount":"0.00","subtotal":"97.50","grand_total":"110.18","paid_amount":"110.18","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":"95638","customer_id":"95638","source_of_creation":"PMS","reservation_created_date":"2020-01-09 18:56:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055983","reservation_id":"89656","confirmation_number":"PB12395092709","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.50","nightly_discount":"0.00","subtotal":"97.50","grand_total":"110.18","paid_amount":"110.18","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":"95641","customer_id":"95641","source_of_creation":"PMS","reservation_created_date":"2020-01-09 20:01:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051072","reservation_id":"88777","confirmation_number":"PB12311816816","room_stay_from":"2020-01-06","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.50,136.50,136.50,136.50,149.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"695.50","grand_total":"785.92","paid_amount":"785.92","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94929","customer_id":"94929","source_of_creation":"PMS","reservation_created_date":"2019-12-27 16:39:15","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054383","reservation_id":"84534","confirmation_number":"PB12353322634","room_stay_from":"2020-01-05","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00,119.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"754.00","grand_total":"852.02","paid_amount":"852.02","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76330","customer_id":"76330","source_of_creation":"PMS","reservation_created_date":"2020-01-05 13:16:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055360","reservation_id":"89577","confirmation_number":"PB12346954162","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.35,90.35,113.69","nightly_discount":"0.00,0.00,0.00","subtotal":"294.39","grand_total":"332.66","paid_amount":"332.66","room_type_id":"289","product_id":"1101","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":"95565","customer_id":"95565","source_of_creation":"PMS","reservation_created_date":"2020-01-08 19:19:26","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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":"3056126","reservation_id":"89280","confirmation_number":"BV12488925903","room_stay_from":"2020-01-06","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.00,91.00,91.00,91.00,91.00","nightly_discount":"16.58,0.00,0.00,0.00,0.00","subtotal":"455.00","grand_total":"495.42","paid_amount":"495.42","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95294","customer_id":"95294","source_of_creation":"PMS","reservation_created_date":"2020-01-04 01:01:21","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"91.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056217","reservation_id":"89679","confirmation_number":"PB12377083441","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.25,136.00","nightly_discount":"0.00,0.00","subtotal":"256.25","grand_total":"289.57","paid_amount":"289.57","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":"95661","customer_id":"95661","source_of_creation":"PMS","reservation_created_date":"2020-01-10 00:51:42","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056111","reservation_id":"88659","confirmation_number":"BP12515027283","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"124.80,137.80,137.80","nightly_discount":"0.00,0.00,18.50,0.00","subtotal":"400.40","grand_total":"431.54","paid_amount":"431.54","room_type_id":"297","product_id":"1132","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":"94841","customer_id":"94841","source_of_creation":"PMS","reservation_created_date":"2019-12-24 20:26:36","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.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":"3056147","reservation_id":"89683","confirmation_number":"PB12388407449","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"90.35,128.69,140.06","nightly_discount":"0.00,0.00,0.00","subtotal":"359.10","grand_total":"405.79","paid_amount":"405.79","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95669","customer_id":"95669","source_of_creation":"PMS","reservation_created_date":"2020-01-10 02:35:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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":"3055673","reservation_id":"89482","confirmation_number":"PB12351951191","room_stay_from":"2020-01-08","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.70,102.70,127.27,140.00,112.97","nightly_discount":"0.00,0.00,0.00,0.00,27.90,0.00","subtotal":"585.64","grand_total":"630.24","paid_amount":"630.25","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":"27078","customer_id":"27078","source_of_creation":"PMS","reservation_created_date":"2020-01-07 01:33:05","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":"","currentDayPrice":"102.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":"3055501","reservation_id":"86281","confirmation_number":"BP12526618144","room_stay_from":"2020-01-09","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"156.00,176.00,176.00,156.00,156.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"820.00","grand_total":"926.60","paid_amount":"926.60","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79127","customer_id":"79127","source_of_creation":"PMS","reservation_created_date":"2019-10-26 15:45:40","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"156.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3050155","reservation_id":"67055","confirmation_number":"PB12350136682","room_stay_from":"2019-12-24","room_stay_to":"2020-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.35,137.00,0.00,0.00,0.00","subtotal":"2877.00","grand_total":"3095.81","paid_amount":"3095.81","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":"69129","customer_id":"69129","source_of_creation":"PMS","reservation_created_date":"2019-01-17 01:59:48","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056085","reservation_id":"85249","confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,164.00,164.00,144.00,144.00,144.00,144.00,144.00,164.00,164.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,132.41,0.00","subtotal":"2240.00","grand_total":"2381.58","paid_amount":"2381.58","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":"33409","customer_id":"33409","source_of_creation":"PMS","reservation_created_date":"2019-10-07 13:41:48","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055088","reservation_id":"69585","confirmation_number":"BP12549690899","room_stay_from":"2020-01-07","room_stay_to":"2020-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00","nightly_discount":"100.00,100.00,100.00,10.18,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"6380.00","grand_total":"6858.90","paid_amount":"6858.90","room_type_id":"302","product_id":"1138","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":"46530","customer_id":"46530","source_of_creation":"PMS","reservation_created_date":"2019-02-16 16:13:23","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"145.00","currentDayDiscount":"100.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056006","reservation_id":"69773","confirmation_number":"BV12434890851","room_stay_from":"2020-01-08","room_stay_to":"2020-03-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,60.62,166.04,166.04,166.04","subtotal":"10958.64","grand_total":"11751.88","paid_amount":"11751.88","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24672","customer_id":"24672","source_of_creation":"PMS","reservation_created_date":"2019-02-18 22:04:05","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3056156","reservation_id":"89687","confirmation_number":"PB12399651837","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"88.00","nightly_discount":"0.00","subtotal":"88.00","grand_total":"88.00","paid_amount":"88.00","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":"1","traveller_tax_exempt":"1","customer_traveller_id":"82871","customer_id":"95672","source_of_creation":"PMS","reservation_created_date":"2020-01-10 03:54:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3055121","reservation_id":"89472","confirmation_number":"PB12265336687","room_confirmation_number":"PB12335579073","room_stay_from":"2020-01-08","room_stay_to":"2020-01-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":"95566","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-01-07 22:38:32","reservation_modified_date_time":"2020-01-07 22:38:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95566","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055129","reservation_id":"89472","confirmation_number":"PB12271807251","room_confirmation_number":"PB12347672469","room_stay_from":"2020-01-08","room_stay_to":"2020-01-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":"95566","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-01-07 22:44:39","reservation_modified_date_time":"2020-01-07 22:44:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95566","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3050053","reservation_id":"88659","confirmation_number":"BP12286911565","room_confirmation_number":"BP12515027283","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"94841","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-12-24 20:26:36","reservation_modified_date_time":"2019-12-24 20:26:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94841","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056148","reservation_id":"89683","confirmation_number":"PB12291547486","room_confirmation_number":"PB12388407449","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"95669","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-01-10 02:35:47","reservation_modified_date_time":"2020-01-10 02:35:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95669","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055503","reservation_id":"86281","confirmation_number":"BP12232100181","room_confirmation_number":"BP12526618144","room_stay_from":"2020-01-09","room_stay_to":"2020-01-14","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0,0,0,0,0","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"79127","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-01-08 23:35:05","reservation_modified_date_time":"2020-01-08 23:35:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79127","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3042914","reservation_id":"87658","confirmation_number":"PB12257724834","room_confirmation_number":"PB12321592123","room_stay_from":"2020-01-01","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"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,0,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"95729","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-30 02:46:09","reservation_modified_date_time":"2019-11-30 02:46:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95729","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3046150","reservation_id":"88170","confirmation_number":"BP12214923305","room_confirmation_number":"BP12533348084","room_stay_from":"2019-12-29","room_stay_to":"2020-01-10","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,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,0.00,0.00","subtotal":"240.00","grand_total":"271.20","paid_amount":"271.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"94493","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-11 19:32:10","reservation_modified_date_time":"2019-12-11 19:32:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94493","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3049745","reservation_id":"88605","confirmation_number":"PB12288735176","room_confirmation_number":"PB12375655650","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","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":"95730","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-23 17:32:08","reservation_modified_date_time":"2019-12-23 17:32:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95730","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3050186","reservation_id":"88673","confirmation_number":"PB12278669512","room_confirmation_number":"PB12386323103","room_stay_from":"2020-01-07","room_stay_to":"2020-01-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":"94848","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-25 11:37:11","reservation_modified_date_time":"2019-12-25 11:37:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94848","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3052876","reservation_id":"89107","confirmation_number":"PB12254107511","room_confirmation_number":"PB12346315732","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95526","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-02 02:27:09","reservation_modified_date_time":"2020-01-02 02:27:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95526","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3053194","reservation_id":"89164","confirmation_number":"PB12243849178","room_confirmation_number":"PB12334473304","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95654","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-02 23:09:09","reservation_modified_date_time":"2020-01-02 23:09:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95654","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3053581","reservation_id":"88468","confirmation_number":"PB12264607909","room_confirmation_number":"PB12333773046","room_stay_from":"2020-01-03","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91746","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-19 15:30:12","reservation_modified_date_time":"2020-01-03 18:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91746","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054712","reservation_id":"88825","confirmation_number":"PB12290331530","room_confirmation_number":"PB12335025083","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95546","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-28 03:27:11","reservation_modified_date_time":"2019-12-28 03:27:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95546","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055122","reservation_id":"89472","confirmation_number":"PB12278660176","room_confirmation_number":"PB12335579073","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95566","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-06 22:15:05","reservation_modified_date_time":"2020-01-06 22:15:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95566","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055130","reservation_id":"89472","confirmation_number":"PB12218034318","room_confirmation_number":"PB12347672469","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95566","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-06 22:15:08","reservation_modified_date_time":"2020-01-06 22:15:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95566","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055346","reservation_id":"88960","confirmation_number":"PB12220995199","room_confirmation_number":"PB12310527525","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","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":"95043","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-30 15:30:02","reservation_modified_date_time":"2020-01-08 19:00:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95043","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055484","reservation_id":"88836","confirmation_number":"BP12218450174","room_confirmation_number":"BP12558992398","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95586","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-28 15:02:05","reservation_modified_date_time":"2019-12-28 15:02:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95586","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055609","reservation_id":"89622","confirmation_number":"PB12211396606","room_confirmation_number":"PB12341794358","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95628","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-09 05:21:11","reservation_modified_date_time":"2020-01-09 05:21:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95628","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055776","reservation_id":"89639","confirmation_number":"BV12261004241","room_confirmation_number":"BV12459968136","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95627","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-09 16:34:11","reservation_modified_date_time":"2020-01-09 16:34:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95627","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055938","reservation_id":"89653","confirmation_number":"PB12234147788","room_confirmation_number":"PB12335013153","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","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":"95638","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-09 18:56:58","reservation_modified_date_time":"2020-01-09 18:56:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95638","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055984","reservation_id":"89656","confirmation_number":"PB12298986426","room_confirmation_number":"PB12395092709","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","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":"95641","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-09 20:01:37","reservation_modified_date_time":"2020-01-09 20:01:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95641","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056116","reservation_id":"89674","confirmation_number":"BV12266247710","room_confirmation_number":"BV12462016364","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95727","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-10 00:06:06","reservation_modified_date_time":"2020-01-10 00:06:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95727","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056118","reservation_id":"89675","confirmation_number":"BP12271948241","room_confirmation_number":"BP12523452859","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95663","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-10 00:13:06","reservation_modified_date_time":"2020-01-10 00:13:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95663","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056317","reservation_id":"89390","confirmation_number":"PB12245273683","room_confirmation_number":"PB12315225265","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","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":"95436","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-05 16:42:11","reservation_modified_date_time":"2020-01-10 18:26:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95436","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051073","reservation_id":"88777","confirmation_number":"PB12284273537","room_confirmation_number":"PB12311816816","room_stay_from":"2020-01-06","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"94929","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-27 16:39:15","reservation_modified_date_time":"2019-12-27 16:39:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94929","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054384","reservation_id":"84534","confirmation_number":"PB12248041924","room_confirmation_number":"PB12353322634","room_stay_from":"2020-01-05","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"76330","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-05 13:16:32","reservation_modified_date_time":"2020-01-05 13:16:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76330","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054683","reservation_id":"89444","confirmation_number":"PB12283468306","room_confirmation_number":"PB12384968944","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95558","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-06 03:47:09","reservation_modified_date_time":"2020-01-06 03:47:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95558","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055204","reservation_id":"89546","confirmation_number":"PB12256219968","room_confirmation_number":"PB12332484135","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95562","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-08 02:57:10","reservation_modified_date_time":"2020-01-08 02:57:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95562","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055361","reservation_id":"89577","confirmation_number":"PB12270259885","room_confirmation_number":"PB12346954162","room_stay_from":"2020-01-08","room_stay_to":"2020-01-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":"95565","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-08 19:19:26","reservation_modified_date_time":"2020-01-08 19:19:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95565","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056127","reservation_id":"89280","confirmation_number":"BV12225802321","room_confirmation_number":"BV12488925903","room_stay_from":"2020-01-06","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95294","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-04 01:01:21","reservation_modified_date_time":"2020-01-06 23:59:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95294","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056218","reservation_id":"89679","confirmation_number":"PB12280939604","room_confirmation_number":"PB12377083441","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"95661","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-10 00:51:42","reservation_modified_date_time":"2020-01-10 15:59:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95661","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042519","reservation_id":"87630","confirmation_number":"BP12295691051","room_confirmation_number":"BP12552858762","room_stay_from":"2020-01-07","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"94124","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-29 19:12:10","reservation_modified_date_time":"2019-11-29 19:12:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95507","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055276","reservation_id":"89561","confirmation_number":"BV12274984052","room_confirmation_number":"BV12482526507","room_stay_from":"2020-01-08","room_stay_to":"2020-01-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":"95545","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-08 15:46:10","reservation_modified_date_time":"2020-01-08 15:46:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95545","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056112","reservation_id":"88659","confirmation_number":"BP12244950422","room_confirmation_number":"BP12515027283","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"94841","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-24 20:26:36","reservation_modified_date_time":"2020-01-09 23:38:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94841","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056149","reservation_id":"89683","confirmation_number":"PB12290356308","room_confirmation_number":"PB12388407449","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"95669","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-10 02:35:47","reservation_modified_date_time":"2020-01-10 02:35:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95669","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3050977","reservation_id":"88753","confirmation_number":"PB12292852863","room_confirmation_number":"PB12358870664","room_stay_from":"2020-01-07","room_stay_to":"2020-01-13","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":"95517","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-27 03:47:08","reservation_modified_date_time":"2019-12-27 03:47:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95518","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055674","reservation_id":"89482","confirmation_number":"PB12215873531","room_confirmation_number":"PB12351951191","room_stay_from":"2020-01-08","room_stay_to":"2020-01-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"27078","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-07 01:33:05","reservation_modified_date_time":"2020-01-09 15:47:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27078","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3046222","reservation_id":"88186","confirmation_number":"PB12210117447","room_confirmation_number":"PB12327566106","room_stay_from":"2020-01-08","room_stay_to":"2020-01-14","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":"95574","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-12 02:12:09","reservation_modified_date_time":"2019-12-12 02:12:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95574","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055504","reservation_id":"86281","confirmation_number":"BP12227132737","room_confirmation_number":"BP12526618144","room_stay_from":"2020-01-09","room_stay_to":"2020-01-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79127","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-26 15:45:40","reservation_modified_date_time":"2020-01-08 23:35:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79127","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042919","reservation_id":"77288","confirmation_number":"PB12249203696","room_confirmation_number":"PB12329998445","room_stay_from":"2020-01-08","room_stay_to":"2020-01-15","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":"95553","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-05-25 00:32:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95553","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3050156","reservation_id":"67055","confirmation_number":"PB12244669360","room_confirmation_number":"PB12350136682","room_stay_from":"2019-12-24","room_stay_to":"2020-01-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"69129","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-17 01:59:48","reservation_modified_date_time":"2019-12-24 22:45:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69129","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056086","reservation_id":"85249","confirmation_number":"BP12268512018","room_confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"33409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-07 13:41:48","reservation_modified_date_time":"2020-01-09 22:21:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33409","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055089","reservation_id":"69585","confirmation_number":"BP12283624317","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-07","room_stay_to":"2020-02-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"46530","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"2020-01-07 19:35:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46530","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056007","reservation_id":"69773","confirmation_number":"BV12212358815","room_confirmation_number":"BV12434890851","room_stay_from":"2020-01-08","room_stay_to":"2020-03-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24672","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-18 22:04:05","reservation_modified_date_time":"2020-01-09 21:11:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24672","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3056157","reservation_id":"89687","confirmation_number":"PB12299150786","room_confirmation_number":"PB12399651837","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","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":"82871","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-10 03:54:08","reservation_modified_date_time":"2020-01-10 03:54:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"95672","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gift_shop_taxable":[{"room_stay_id":"2936334","reservation_id":"69585","confirmation_number":"BP12214447507","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-04","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"46530","parentCustTravId":"46530","customer_traveller_id":"46530","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3055727","reservation_id":"86281","confirmation_number":"BP12237160072","room_confirmation_number":"BP12526618144","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 16:25:28","reservation_modified_date_time":"2020-01-09 16:25:28","customer_id":"79127","parentCustTravId":"79127","customer_traveller_id":"79127","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3055749","reservation_id":"89622","confirmation_number":"PB12245875967","room_confirmation_number":"PB12341794358","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":"1213","service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 16:31:52","reservation_modified_date_time":"2020-01-09 16:31:52","customer_id":"95628","parentCustTravId":"95628","customer_traveller_id":"95628","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3056034","reservation_id":"85249","confirmation_number":"BP12238920508","room_confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"375.00","grand_total":"423.75","paid_amount":"423.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 22:16:26","reservation_modified_date_time":"2020-01-09 22:16:26","customer_id":"33409","parentCustTravId":"33409","customer_traveller_id":"33409","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3056459","reservation_id":"89679","confirmation_number":"PB12295073776","room_confirmation_number":"PB12377083441","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-10 22:31:41","reservation_modified_date_time":"2020-01-10 22:31:41","customer_id":"95661","parentCustTravId":"95661","customer_traveller_id":"95661","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3055666","reservation_id":"89632","confirmation_number":"PB12210784257","room_confirmation_number":"PB12325005365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 15:18:10","reservation_modified_date_time":"2020-01-09 15:18:10","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3055917","reservation_id":"89647","confirmation_number":"PB12247430293","room_confirmation_number":"PB12355634680","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 17:52:45","reservation_modified_date_time":"2020-01-09 17:52:45","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123","departureCount":7,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1096,1092,1098,1084","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12297425017","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","bundle_room":"0"},{"confirmation_number":"PB12290559301","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","bundle_room":"0"},{"confirmation_number":"PB12229238888","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","bundle_room":"0"},{"confirmation_number":"PB12217614016","room_stay_from":"2020-01-06","room_stay_to":"2020-01-09","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3042913","reservation_id":"87658","confirmation_number":"PB12321592123","room_stay_from":"2020-01-01","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,172.80,172.80,160.80,160.80,160.80,160.80,160.80","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1471.20","grand_total":"1662.45","paid_amount":"1662.45","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-3400601347","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":"95729","customer_id":"95729","source_of_creation":"Booking.com","reservation_created_date":"2019-11-30 02:46:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"110.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.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"}]},{"room_stay_id":"3042918","reservation_id":"77288","confirmation_number":"PB12329998445","room_stay_from":"2020-01-08","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.20,174.20,187.20,187.20,174.20,174.20,174.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1245.40","grand_total":"1407.30","paid_amount":"1407.30","room_type_id":"291","product_id":"1117","siteminder_id":"BDC-3043400641","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":"95553","customer_id":"95553","source_of_creation":"Booking.com","reservation_created_date":"2019-05-25 00:32:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"186.81","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3049744","reservation_id":"88605","confirmation_number":"PB12375655650","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.27,73.27,73.27,73.27","nightly_discount":"0,0,0,0","subtotal":"293.08","grand_total":"331.18","paid_amount":"331.18","room_type_id":"292","product_id":"1120","siteminder_id":"EXP-1611617683","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":"95730","customer_id":"95730","source_of_creation":"Expedia","reservation_created_date":"2019-12-23 17:32:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.27","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":"3056316","reservation_id":"89390","confirmation_number":"PB12315225265","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.16,75.16,75.16,75.16","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"300.64","grand_total":"339.72","paid_amount":"339.72","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1617705611","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":"95436","customer_id":"95436","source_of_creation":"Expedia","reservation_created_date":"2020-01-05 16:42:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054682","reservation_id":"89444","confirmation_number":"PB12384968944","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.83,132.83,154.32","nightly_discount":"0,0,0","subtotal":"419.98","grand_total":"474.58","paid_amount":"474.58","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1617989080","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":"95558","customer_id":"95558","source_of_creation":"Expedia","reservation_created_date":"2020-01-06 03:47:09","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.83","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":"3055203","reservation_id":"89546","confirmation_number":"PB12332484135","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.92,106.92,127.63","nightly_discount":"0,0,0","subtotal":"341.47","grand_total":"385.86","paid_amount":"385.86","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1619158642","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":"95562","customer_id":"95562","source_of_creation":"Expedia","reservation_created_date":"2020-01-08 02:57:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.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":"3050976","reservation_id":"88753","confirmation_number":"PB12358870664","room_stay_from":"2020-01-07","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.84,92.84,92.84,99.77,99.77,92.84","nightly_discount":"0,0,0,0,0,0","subtotal":"570.90","grand_total":"645.11","paid_amount":"645.11","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1613050626","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":"95517","customer_id":"95518","source_of_creation":"Expedia","reservation_created_date":"2019-12-27 03:47:08","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":"","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"}]},{"room_stay_id":"3046221","reservation_id":"88186","confirmation_number":"PB12327566106","room_stay_from":"2020-01-08","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.56,128.56,138.15,138.15,128.56,128.56","nightly_discount":"0,0,0,0,0,0","subtotal":"790.54","grand_total":"893.31","paid_amount":"893.31","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1606444384","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":"95574","customer_id":"95574","source_of_creation":"Expedia","reservation_created_date":"2019-12-12 02:12:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.56","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_non_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3052875","reservation_id":"89107","confirmation_number":"PB12346315732","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.38,84.38,84.38","nightly_discount":"0,0,0","subtotal":"253.14","grand_total":"286.05","paid_amount":"286.05","room_type_id":"286","product_id":"1086","siteminder_id":"AGO-300324026","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":"95526","customer_id":"95526","source_of_creation":"Agoda","reservation_created_date":"2020-01-02 02:27:09","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":"","currentDayPrice":"84.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":"3053193","reservation_id":"89164","confirmation_number":"PB12334473304","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.79","nightly_discount":"0","subtotal":"71.79","grand_total":"81.13","paid_amount":"81.13","room_type_id":"289","product_id":"1093","siteminder_id":"AGO-300490674","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":"95654","customer_id":"95654","source_of_creation":"Agoda","reservation_created_date":"2020-01-02 23:09:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.79","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":"3054711","reservation_id":"88825","confirmation_number":"PB12335025083","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.71,74.71","nightly_discount":"0,0","subtotal":"149.42","grand_total":"168.85","paid_amount":"168.85","room_type_id":"285","product_id":"1083","siteminder_id":"AGO-299338594","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":"95546","customer_id":"95546","source_of_creation":"Agoda","reservation_created_date":"2019-12-28 03:27:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.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":"3055120","reservation_id":"89472","confirmation_number":"PB12335579073","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"71.79,71.79","nightly_discount":"0,0","subtotal":"143.58","grand_total":"162.24","paid_amount":"162.24","room_type_id":"289","product_id":"1121","siteminder_id":"AGO-301289098","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95566","customer_id":"95566","source_of_creation":"Agoda","reservation_created_date":"2020-01-06 22:15:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.79","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":"3055128","reservation_id":"89472","confirmation_number":"PB12347672469","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"71.79,71.79","nightly_discount":"0,0","subtotal":"143.58","grand_total":"162.24","paid_amount":"162.24","room_type_id":"289","product_id":"1123","siteminder_id":"AGO-301289098","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95566","customer_id":"95566","source_of_creation":"Agoda","reservation_created_date":"2020-01-06 22:15:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.79","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":"3055608","reservation_id":"89622","confirmation_number":"PB12341794358","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.21","nightly_discount":"0","subtotal":"67.21","grand_total":"75.94","paid_amount":"75.94","room_type_id":"290","product_id":"1113","siteminder_id":"AGO-301768490","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":"95628","customer_id":"95628","source_of_creation":"Agoda","reservation_created_date":"2020-01-09 05:21:11","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.21","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3050185","reservation_id":"88673","confirmation_number":"PB12386323103","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.50,136.50,136.50","nightly_discount":"0.00,0.00,0.00","subtotal":"409.50","grand_total":"462.74","paid_amount":"462.74","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94848","customer_id":"94848","source_of_creation":"FE","reservation_created_date":"2019-12-25 11:37:11","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055345","reservation_id":"88960","confirmation_number":"PB12310527525","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.35,90.35,90.35,90.35","nightly_discount":"0.00,0.00,0.00,16.39,0.00","subtotal":"361.40","grand_total":"389.86","paid_amount":"389.86","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":"95043","customer_id":"95043","source_of_creation":"FE","reservation_created_date":"2019-12-30 15:30:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.35","currentDayDiscount":"16.39","productIsTaxExempt":false,"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":"3053580","reservation_id":"88468","confirmation_number":"PB12333773046","room_stay_from":"2020-01-03","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,32.74,0.00","subtotal":"623.00","grand_total":"667.00","paid_amount":"667.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":"91746","customer_id":"91746","source_of_creation":"PMS","reservation_created_date":"2019-12-19 15:30:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.00","currentDayDiscount":"32.74","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055937","reservation_id":"89653","confirmation_number":"PB12335013153","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.50","nightly_discount":"0.00","subtotal":"97.50","grand_total":"110.18","paid_amount":"110.18","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":"95638","customer_id":"95638","source_of_creation":"PMS","reservation_created_date":"2020-01-09 18:56:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055983","reservation_id":"89656","confirmation_number":"PB12395092709","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.50","nightly_discount":"0.00","subtotal":"97.50","grand_total":"110.18","paid_amount":"110.18","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":"95641","customer_id":"95641","source_of_creation":"PMS","reservation_created_date":"2020-01-09 20:01:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051072","reservation_id":"88777","confirmation_number":"PB12311816816","room_stay_from":"2020-01-06","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.50,136.50,136.50,136.50,149.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"695.50","grand_total":"785.92","paid_amount":"785.92","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94929","customer_id":"94929","source_of_creation":"PMS","reservation_created_date":"2019-12-27 16:39:15","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054383","reservation_id":"84534","confirmation_number":"PB12353322634","room_stay_from":"2020-01-05","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00,119.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"754.00","grand_total":"852.02","paid_amount":"852.02","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76330","customer_id":"76330","source_of_creation":"PMS","reservation_created_date":"2020-01-05 13:16:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055360","reservation_id":"89577","confirmation_number":"PB12346954162","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.35,90.35,113.69","nightly_discount":"0.00,0.00,0.00","subtotal":"294.39","grand_total":"332.66","paid_amount":"332.66","room_type_id":"289","product_id":"1101","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":"95565","customer_id":"95565","source_of_creation":"PMS","reservation_created_date":"2020-01-08 19:19:26","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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":"3056217","reservation_id":"89679","confirmation_number":"PB12377083441","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.25,136.00","nightly_discount":"0.00,0.00","subtotal":"256.25","grand_total":"289.57","paid_amount":"289.57","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":"95661","customer_id":"95661","source_of_creation":"PMS","reservation_created_date":"2020-01-10 00:51:42","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056147","reservation_id":"89683","confirmation_number":"PB12388407449","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"90.35,128.69,140.06","nightly_discount":"0.00,0.00,0.00","subtotal":"359.10","grand_total":"405.79","paid_amount":"405.79","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95669","customer_id":"95669","source_of_creation":"PMS","reservation_created_date":"2020-01-10 02:35:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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":"3055673","reservation_id":"89482","confirmation_number":"PB12351951191","room_stay_from":"2020-01-08","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.70,102.70,127.27,140.00,112.97","nightly_discount":"0.00,0.00,0.00,0.00,27.90,0.00","subtotal":"585.64","grand_total":"630.24","paid_amount":"630.25","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":"27078","customer_id":"27078","source_of_creation":"PMS","reservation_created_date":"2020-01-07 01:33:05","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":"","currentDayPrice":"102.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":"3050155","reservation_id":"67055","confirmation_number":"PB12350136682","room_stay_from":"2019-12-24","room_stay_to":"2020-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.35,137.00,0.00,0.00,0.00","subtotal":"2877.00","grand_total":"3095.81","paid_amount":"3095.81","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":"69129","customer_id":"69129","source_of_creation":"PMS","reservation_created_date":"2019-01-17 01:59:48","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3056156","reservation_id":"89687","confirmation_number":"PB12399651837","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"88.00","nightly_discount":"0.00","subtotal":"88.00","grand_total":"88.00","paid_amount":"88.00","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":"1","traveller_tax_exempt":"1","customer_traveller_id":"82871","customer_id":"95672","source_of_creation":"PMS","reservation_created_date":"2020-01-10 03:54:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3055121","reservation_id":"89472","confirmation_number":"PB12265336687","room_confirmation_number":"PB12335579073","room_stay_from":"2020-01-08","room_stay_to":"2020-01-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":"95566","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-01-07 22:38:32","reservation_modified_date_time":"2020-01-07 22:38:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95566","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055129","reservation_id":"89472","confirmation_number":"PB12271807251","room_confirmation_number":"PB12347672469","room_stay_from":"2020-01-08","room_stay_to":"2020-01-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":"95566","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-01-07 22:44:39","reservation_modified_date_time":"2020-01-07 22:44:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95566","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056148","reservation_id":"89683","confirmation_number":"PB12291547486","room_confirmation_number":"PB12388407449","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"95669","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-01-10 02:35:47","reservation_modified_date_time":"2020-01-10 02:35:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95669","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3042914","reservation_id":"87658","confirmation_number":"PB12257724834","room_confirmation_number":"PB12321592123","room_stay_from":"2020-01-01","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"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,0,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"95729","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-30 02:46:09","reservation_modified_date_time":"2019-11-30 02:46:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95729","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3049745","reservation_id":"88605","confirmation_number":"PB12288735176","room_confirmation_number":"PB12375655650","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","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":"95730","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-23 17:32:08","reservation_modified_date_time":"2019-12-23 17:32:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95730","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3050186","reservation_id":"88673","confirmation_number":"PB12278669512","room_confirmation_number":"PB12386323103","room_stay_from":"2020-01-07","room_stay_to":"2020-01-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":"94848","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-25 11:37:11","reservation_modified_date_time":"2019-12-25 11:37:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94848","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3052876","reservation_id":"89107","confirmation_number":"PB12254107511","room_confirmation_number":"PB12346315732","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95526","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-02 02:27:09","reservation_modified_date_time":"2020-01-02 02:27:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95526","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3053194","reservation_id":"89164","confirmation_number":"PB12243849178","room_confirmation_number":"PB12334473304","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95654","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-02 23:09:09","reservation_modified_date_time":"2020-01-02 23:09:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95654","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3053581","reservation_id":"88468","confirmation_number":"PB12264607909","room_confirmation_number":"PB12333773046","room_stay_from":"2020-01-03","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91746","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-19 15:30:12","reservation_modified_date_time":"2020-01-03 18:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91746","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054712","reservation_id":"88825","confirmation_number":"PB12290331530","room_confirmation_number":"PB12335025083","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95546","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-28 03:27:11","reservation_modified_date_time":"2019-12-28 03:27:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95546","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055122","reservation_id":"89472","confirmation_number":"PB12278660176","room_confirmation_number":"PB12335579073","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95566","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-06 22:15:05","reservation_modified_date_time":"2020-01-06 22:15:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95566","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055130","reservation_id":"89472","confirmation_number":"PB12218034318","room_confirmation_number":"PB12347672469","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95566","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-06 22:15:08","reservation_modified_date_time":"2020-01-06 22:15:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95566","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055346","reservation_id":"88960","confirmation_number":"PB12220995199","room_confirmation_number":"PB12310527525","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","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":"95043","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-30 15:30:02","reservation_modified_date_time":"2020-01-08 19:00:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95043","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055609","reservation_id":"89622","confirmation_number":"PB12211396606","room_confirmation_number":"PB12341794358","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95628","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-09 05:21:11","reservation_modified_date_time":"2020-01-09 05:21:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95628","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055938","reservation_id":"89653","confirmation_number":"PB12234147788","room_confirmation_number":"PB12335013153","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","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":"95638","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-09 18:56:58","reservation_modified_date_time":"2020-01-09 18:56:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95638","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055984","reservation_id":"89656","confirmation_number":"PB12298986426","room_confirmation_number":"PB12395092709","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","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":"95641","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-09 20:01:37","reservation_modified_date_time":"2020-01-09 20:01:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95641","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056317","reservation_id":"89390","confirmation_number":"PB12245273683","room_confirmation_number":"PB12315225265","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","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":"95436","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-05 16:42:11","reservation_modified_date_time":"2020-01-10 18:26:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95436","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051073","reservation_id":"88777","confirmation_number":"PB12284273537","room_confirmation_number":"PB12311816816","room_stay_from":"2020-01-06","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"94929","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-27 16:39:15","reservation_modified_date_time":"2019-12-27 16:39:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94929","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054384","reservation_id":"84534","confirmation_number":"PB12248041924","room_confirmation_number":"PB12353322634","room_stay_from":"2020-01-05","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"76330","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-05 13:16:32","reservation_modified_date_time":"2020-01-05 13:16:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76330","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3054683","reservation_id":"89444","confirmation_number":"PB12283468306","room_confirmation_number":"PB12384968944","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95558","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-06 03:47:09","reservation_modified_date_time":"2020-01-06 03:47:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95558","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055204","reservation_id":"89546","confirmation_number":"PB12256219968","room_confirmation_number":"PB12332484135","room_stay_from":"2020-01-08","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95562","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-08 02:57:10","reservation_modified_date_time":"2020-01-08 02:57:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95562","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055361","reservation_id":"89577","confirmation_number":"PB12270259885","room_confirmation_number":"PB12346954162","room_stay_from":"2020-01-08","room_stay_to":"2020-01-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":"95565","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-08 19:19:26","reservation_modified_date_time":"2020-01-08 19:19:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95565","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056218","reservation_id":"89679","confirmation_number":"PB12280939604","room_confirmation_number":"PB12377083441","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"95661","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-10 00:51:42","reservation_modified_date_time":"2020-01-10 15:59:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95661","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056149","reservation_id":"89683","confirmation_number":"PB12290356308","room_confirmation_number":"PB12388407449","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"95669","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-10 02:35:47","reservation_modified_date_time":"2020-01-10 02:35:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95669","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3050977","reservation_id":"88753","confirmation_number":"PB12292852863","room_confirmation_number":"PB12358870664","room_stay_from":"2020-01-07","room_stay_to":"2020-01-13","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":"95517","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-27 03:47:08","reservation_modified_date_time":"2019-12-27 03:47:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95518","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055674","reservation_id":"89482","confirmation_number":"PB12215873531","room_confirmation_number":"PB12351951191","room_stay_from":"2020-01-08","room_stay_to":"2020-01-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"27078","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-07 01:33:05","reservation_modified_date_time":"2020-01-09 15:47:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27078","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3046222","reservation_id":"88186","confirmation_number":"PB12210117447","room_confirmation_number":"PB12327566106","room_stay_from":"2020-01-08","room_stay_to":"2020-01-14","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":"95574","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-12 02:12:09","reservation_modified_date_time":"2019-12-12 02:12:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95574","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042919","reservation_id":"77288","confirmation_number":"PB12249203696","room_confirmation_number":"PB12329998445","room_stay_from":"2020-01-08","room_stay_to":"2020-01-15","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":"95553","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-05-25 00:32:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95553","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3050156","reservation_id":"67055","confirmation_number":"PB12244669360","room_confirmation_number":"PB12350136682","room_stay_from":"2019-12-24","room_stay_to":"2020-01-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"69129","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-17 01:59:48","reservation_modified_date_time":"2019-12-24 22:45:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69129","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3056157","reservation_id":"89687","confirmation_number":"PB12299150786","room_confirmation_number":"PB12399651837","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","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":"82871","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-10 03:54:08","reservation_modified_date_time":"2020-01-10 03:54:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"95672","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gift_shop_taxable":[{"room_stay_id":"3055749","reservation_id":"89622","confirmation_number":"PB12245875967","room_confirmation_number":"PB12341794358","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":"1213","service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 16:31:52","reservation_modified_date_time":"2020-01-09 16:31:52","customer_id":"95628","parentCustTravId":"95628","customer_traveller_id":"95628","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3056459","reservation_id":"89679","confirmation_number":"PB12295073776","room_confirmation_number":"PB12377083441","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-10 22:31:41","reservation_modified_date_time":"2020-01-10 22:31:41","customer_id":"95661","parentCustTravId":"95661","customer_traveller_id":"95661","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3055666","reservation_id":"89632","confirmation_number":"PB12210784257","room_confirmation_number":"PB12325005365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 15:18:10","reservation_modified_date_time":"2020-01-09 15:18:10","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3055917","reservation_id":"89647","confirmation_number":"PB12247430293","room_confirmation_number":"PB12355634680","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 17:52:45","reservation_modified_date_time":"2020-01-09 17:52:45","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":2,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3056115","reservation_id":"89674","confirmation_number":"BV12462016364","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.60","nightly_discount":"0","subtotal":"48.60","grand_total":"54.92","paid_amount":"54.92","room_type_id":"303","product_id":"1139","siteminder_id":"HWR-301584988","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":"95727","customer_id":"95727","source_of_creation":"Hotwire","reservation_created_date":"2020-01-10 00:06:06","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.60","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"}]}],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3055275","reservation_id":"89561","confirmation_number":"BV12482526507","room_stay_from":"2020-01-08","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.63,92.63,115.47,115.47","nightly_discount":"0,0,0,0","subtotal":"416.20","grand_total":"470.30","paid_amount":"470.30","room_type_id":"304","product_id":"1218","siteminder_id":"GCC-0005100055-a6c","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":"95545","customer_id":"95545","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-01-08 15:46:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.63","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3055775","reservation_id":"89639","confirmation_number":"BV12459968136","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.51","nightly_discount":"0","subtotal":"67.51","grand_total":"76.29","paid_amount":"76.29","room_type_id":"307","product_id":"1224","siteminder_id":"AGO-301824354","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":"95627","customer_id":"95627","source_of_creation":"Agoda","reservation_created_date":"2020-01-09 16:34:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.51","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3056126","reservation_id":"89280","confirmation_number":"BV12488925903","room_stay_from":"2020-01-06","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.00,91.00,91.00,91.00,91.00","nightly_discount":"16.58,0.00,0.00,0.00,0.00","subtotal":"455.00","grand_total":"495.42","paid_amount":"495.42","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95294","customer_id":"95294","source_of_creation":"PMS","reservation_created_date":"2020-01-04 01:01:21","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"91.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056006","reservation_id":"69773","confirmation_number":"BV12434890851","room_stay_from":"2020-01-08","room_stay_to":"2020-03-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,60.62,166.04,166.04,166.04","subtotal":"10958.64","grand_total":"11751.88","paid_amount":"11751.88","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24672","customer_id":"24672","source_of_creation":"PMS","reservation_created_date":"2019-02-18 22:04:05","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3055776","reservation_id":"89639","confirmation_number":"BV12261004241","room_confirmation_number":"BV12459968136","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95627","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-09 16:34:11","reservation_modified_date_time":"2020-01-09 16:34:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95627","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056116","reservation_id":"89674","confirmation_number":"BV12266247710","room_confirmation_number":"BV12462016364","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95727","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-10 00:06:06","reservation_modified_date_time":"2020-01-10 00:06:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95727","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056127","reservation_id":"89280","confirmation_number":"BV12225802321","room_confirmation_number":"BV12488925903","room_stay_from":"2020-01-06","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95294","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-04 01:01:21","reservation_modified_date_time":"2020-01-06 23:59:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95294","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055276","reservation_id":"89561","confirmation_number":"BV12274984052","room_confirmation_number":"BV12482526507","room_stay_from":"2020-01-08","room_stay_to":"2020-01-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":"95545","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-08 15:46:10","reservation_modified_date_time":"2020-01-08 15:46:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95545","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056007","reservation_id":"69773","confirmation_number":"BV12212358815","room_confirmation_number":"BV12434890851","room_stay_from":"2020-01-08","room_stay_to":"2020-03-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24672","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-18 22:04:05","reservation_modified_date_time":"2020-01-09 21:11:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24672","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3055483","reservation_id":"88836","confirmation_number":"BP12558992398","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.12,83.85","nightly_discount":"0,0.00","subtotal":"166.97","grand_total":"188.68","paid_amount":"188.68","room_type_id":"298","product_id":"1133","siteminder_id":"BDC-3898643323","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":"95586","customer_id":"95586","source_of_creation":"Booking.com","reservation_created_date":"2019-12-28 15:02:05","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"14.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042518","reservation_id":"87630","confirmation_number":"BP12552858762","room_stay_from":"2020-01-07","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.75,118.75,118.75,130.45,130.45","nightly_discount":"0,0,0,0,0","subtotal":"617.15","grand_total":"697.38","paid_amount":"697.38","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-2182499427","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":"94124","customer_id":"95507","source_of_creation":"Booking.com","reservation_created_date":"2019-11-29 19:12:10","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"92.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.75","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":"3046149","reservation_id":"88170","confirmation_number":"BP12533348084","room_stay_from":"2019-12-29","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.09,97.09,97.09,97.38,97.38,106.97,106.97,97.38,97.38,97.38,97.38,97.38","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1186.87","grand_total":"1341.16","paid_amount":"1341.16","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1389938151","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":"94493","customer_id":"94493","source_of_creation":"Expedia","reservation_created_date":"2019-12-11 19:32:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.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"}]}],"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":[{"room_stay_id":"3056117","reservation_id":"89675","confirmation_number":"BP12523452859","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.60","nightly_discount":"0","subtotal":"48.60","grand_total":"54.92","paid_amount":"54.92","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-301586478","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":"95663","customer_id":"95663","source_of_creation":"Hotwire","reservation_created_date":"2020-01-10 00:13:06","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.60","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"}]}],"hwr_non_taxable":[],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3056111","reservation_id":"88659","confirmation_number":"BP12515027283","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"124.80,137.80,137.80","nightly_discount":"0.00,0.00,18.50,0.00","subtotal":"400.40","grand_total":"431.54","paid_amount":"431.54","room_type_id":"297","product_id":"1132","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":"94841","customer_id":"94841","source_of_creation":"PMS","reservation_created_date":"2019-12-24 20:26:36","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.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":"3055501","reservation_id":"86281","confirmation_number":"BP12526618144","room_stay_from":"2020-01-09","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"156.00,176.00,176.00,156.00,156.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"820.00","grand_total":"926.60","paid_amount":"926.60","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79127","customer_id":"79127","source_of_creation":"PMS","reservation_created_date":"2019-10-26 15:45:40","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"156.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056085","reservation_id":"85249","confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,164.00,164.00,144.00,144.00,144.00,144.00,144.00,164.00,164.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,132.41,0.00","subtotal":"2240.00","grand_total":"2381.58","paid_amount":"2381.58","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":"33409","customer_id":"33409","source_of_creation":"PMS","reservation_created_date":"2019-10-07 13:41:48","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055088","reservation_id":"69585","confirmation_number":"BP12549690899","room_stay_from":"2020-01-07","room_stay_to":"2020-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00","nightly_discount":"100.00,100.00,100.00,10.18,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"6380.00","grand_total":"6858.90","paid_amount":"6858.90","room_type_id":"302","product_id":"1138","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":"46530","customer_id":"46530","source_of_creation":"PMS","reservation_created_date":"2019-02-16 16:13:23","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"145.00","currentDayDiscount":"100.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3050053","reservation_id":"88659","confirmation_number":"BP12286911565","room_confirmation_number":"BP12515027283","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"94841","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-12-24 20:26:36","reservation_modified_date_time":"2019-12-24 20:26:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94841","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055503","reservation_id":"86281","confirmation_number":"BP12232100181","room_confirmation_number":"BP12526618144","room_stay_from":"2020-01-09","room_stay_to":"2020-01-14","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0,0,0,0,0","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"79127","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-01-08 23:35:05","reservation_modified_date_time":"2020-01-08 23:35:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79127","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3046150","reservation_id":"88170","confirmation_number":"BP12214923305","room_confirmation_number":"BP12533348084","room_stay_from":"2019-12-29","room_stay_to":"2020-01-10","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,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,0.00,0.00","subtotal":"240.00","grand_total":"271.20","paid_amount":"271.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"94493","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-11 19:32:10","reservation_modified_date_time":"2019-12-11 19:32:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94493","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055484","reservation_id":"88836","confirmation_number":"BP12218450174","room_confirmation_number":"BP12558992398","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95586","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-28 15:02:05","reservation_modified_date_time":"2019-12-28 15:02:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95586","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056118","reservation_id":"89675","confirmation_number":"BP12271948241","room_confirmation_number":"BP12523452859","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95663","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-10 00:13:06","reservation_modified_date_time":"2020-01-10 00:13:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95663","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042519","reservation_id":"87630","confirmation_number":"BP12295691051","room_confirmation_number":"BP12552858762","room_stay_from":"2020-01-07","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"94124","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-29 19:12:10","reservation_modified_date_time":"2019-11-29 19:12:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95507","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056112","reservation_id":"88659","confirmation_number":"BP12244950422","room_confirmation_number":"BP12515027283","room_stay_from":"2020-01-09","room_stay_to":"2020-01-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"94841","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-24 20:26:36","reservation_modified_date_time":"2020-01-09 23:38:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94841","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055504","reservation_id":"86281","confirmation_number":"BP12227132737","room_confirmation_number":"BP12526618144","room_stay_from":"2020-01-09","room_stay_to":"2020-01-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79127","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-26 15:45:40","reservation_modified_date_time":"2020-01-08 23:35:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79127","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056086","reservation_id":"85249","confirmation_number":"BP12268512018","room_confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"33409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-07 13:41:48","reservation_modified_date_time":"2020-01-09 22:21:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33409","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055089","reservation_id":"69585","confirmation_number":"BP12283624317","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-07","room_stay_to":"2020-02-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"46530","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"2020-01-07 19:35:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46530","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gift_shop_taxable":[{"room_stay_id":"2936334","reservation_id":"69585","confirmation_number":"BP12214447507","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-04","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"46530","parentCustTravId":"46530","customer_traveller_id":"46530","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3055727","reservation_id":"86281","confirmation_number":"BP12237160072","room_confirmation_number":"BP12526618144","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 16:25:28","reservation_modified_date_time":"2020-01-09 16:25:28","customer_id":"79127","parentCustTravId":"79127","customer_traveller_id":"79127","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3056034","reservation_id":"85249","confirmation_number":"BP12238920508","room_confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"375.00","grand_total":"423.75","paid_amount":"423.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 22:16:26","reservation_modified_date_time":"2020-01-09 22:16:26","customer_id":"33409","parentCustTravId":"33409","customer_traveller_id":"33409","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}