{"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":23,"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":"3009611","reservation_id":"81751","confirmation_number":"PB12339098834","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"4","nightly_price":"160.25,128.05,128.05,128.05","nightly_discount":"0.00,0.00,0.00,33.01,0.00","subtotal":"544.40","grand_total":"577.87","paid_amount":"577.87","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-3482870974","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89617","customer_id":"89617","source_of_creation":"Booking.com","reservation_created_date":"2019-07-31 14:48:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"99.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2987115","reservation_id":"78489","confirmation_number":"PB12389442012","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.76,102.76,99.92","nightly_discount":"0,0,0","subtotal":"305.44","grand_total":"345.15","paid_amount":"345.15","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1276009003","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":"87541","customer_id":"87541","source_of_creation":"Expedia","reservation_created_date":"2019-06-11 21:06:08","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":"99.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":"2991509","reservation_id":"79517","confirmation_number":"PB12360497460","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.62,118.90","nightly_discount":"0,0","subtotal":"267.52","grand_total":"302.30","paid_amount":"302.30","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1284904201","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":"88081","customer_id":"88081","source_of_creation":"Expedia","reservation_created_date":"2019-06-24 15:25:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"148.62","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":"2996504","reservation_id":"79300","confirmation_number":"PB12355711020","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"174.64,174.64,175.35,140.28,140.28","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"805.19","grand_total":"909.86","paid_amount":"909.86","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1282460344","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":"87944","customer_id":"87944","source_of_creation":"Expedia","reservation_created_date":"2019-06-20 21:05:10","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":"140.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2997312","reservation_id":"79643","confirmation_number":"PB12382874275","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.16,164.16,161.00","nightly_discount":"0,0,0","subtotal":"489.32","grand_total":"552.93","paid_amount":"552.93","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1286634874","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":"88184","customer_id":"88184","source_of_creation":"Expedia","reservation_created_date":"2019-06-26 18:44:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.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":"3003833","reservation_id":"81552","confirmation_number":"PB12370869808","room_stay_from":"2019-08-10","room_stay_to":"2019-08-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.62,132.02,105.62,105.62,105.62,105.62","nightly_discount":"0,0,0,0,0,0","subtotal":"689.12","grand_total":"778.71","paid_amount":"778.71","room_type_id":"289","product_id":"1109","siteminder_id":"EXP-1309325006","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":"89450","customer_id":"89450","source_of_creation":"Expedia","reservation_created_date":"2019-07-27 17:09:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3005615","reservation_id":"81841","confirmation_number":"PB12336427857","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"104.46,80.09,80.09,80.09","nightly_discount":"0,0,0,0","subtotal":"344.73","grand_total":"389.54","paid_amount":"389.54","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1312998522","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89682","customer_id":"89682","source_of_creation":"Expedia","reservation_created_date":"2019-08-01 19:42:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.46","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009577","reservation_id":"79286","confirmation_number":"PB12389725674","room_stay_from":"2019-08-07","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"151.39,151.39,148.50,148.50,151.39,141.39","nightly_discount":"0.00,45.00,0.00,0.00,0.00,0.00","subtotal":"892.56","grand_total":"957.74","paid_amount":"957.74","room_type_id":"288","product_id":"1091","siteminder_id":"EXP-1282352394","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"240.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87934","customer_id":"87934","source_of_creation":"Expedia","reservation_created_date":"2019-06-20 18:15:10","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"151.39","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_taxable":[{"room_stay_id":"2990398","reservation_id":"79337","confirmation_number":"PB12388297548","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.23,49.02,38.97,38.97,38.97","nightly_discount":"0,0,0,0,0","subtotal":"216.16","grand_total":"244.26","paid_amount":"244.26","room_type_id":"285","product_id":"1083","siteminder_id":"HTN-88883820-GCY3YQ","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":"73295","customer_id":"73295","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-21 16:52:04","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":"49.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2991511","reservation_id":"79513","confirmation_number":"PB12315933154","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.02,38.97","nightly_discount":"0,0","subtotal":"87.99","grand_total":"99.43","paid_amount":"99.43","room_type_id":"285","product_id":"1085","siteminder_id":"HTN-89214162-Q392FV","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":"72925","customer_id":"72925","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-24 14:07:08","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":"49.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008774","reservation_id":"82316","confirmation_number":"PB12341200209","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.17,54.24,66.64,85.99","nightly_discount":"0,0,0,0","subtotal":"290.04","grand_total":"327.74","paid_amount":"327.74","room_type_id":"292","product_id":"1120","siteminder_id":"HTN-95186185-LQ92PM","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":"73295","customer_id":"73295","source_of_creation":"HotelTonight","reservation_created_date":"2019-08-09 16:03:13","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":"83.17","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2993060","reservation_id":"79794","confirmation_number":"PB12380957904","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.70,161.70,146.61","nightly_discount":"0.00,0.00,17.76,0.00","subtotal":"470.01","grand_total":"511.05","paid_amount":"511.05","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":"88291","customer_id":"88291","source_of_creation":"FE","reservation_created_date":"2019-06-28 18:07:56","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":"146.61","currentDayDiscount":"17.76","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3004350","reservation_id":"79794","confirmation_number":"PB12378389803","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.70,161.70,146.61","nightly_discount":"0.00,0.00,17.76","subtotal":"470.01","grand_total":"511.05","paid_amount":"511.05","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88291","customer_id":"88291","source_of_creation":"FE","reservation_created_date":"2019-06-28 18:07:56","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":"146.61","currentDayDiscount":"17.76","productIsTaxExempt":false,"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":"2962779","reservation_id":"74034","confirmation_number":"PB12348835370","room_stay_from":"2019-08-08","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.00,316.00,316.00,266.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1164.00","grand_total":"1315.32","paid_amount":"1315.32","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":"84616","customer_id":"84616","source_of_creation":"PMS","reservation_created_date":"2019-04-04 18:07:20","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":"266.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2979086","reservation_id":"53432","confirmation_number":"PB12374646801","room_stay_from":"2019-08-06","room_stay_to":"2019-08-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.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","subtotal":"1888.00","grand_total":"2133.44","paid_amount":"2133.44","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23537","customer_id":"23537","source_of_creation":"PMS","reservation_created_date":"2018-08-11 17:56:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2989304","reservation_id":"54228","confirmation_number":"PB12320020546","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"600.00","grand_total":"678.00","paid_amount":"678.00","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":"73295","customer_id":"73295","source_of_creation":"PMS","reservation_created_date":"2018-08-23 00:48:22","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2989308","reservation_id":"78883","confirmation_number":"PB12347855915","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"600.00","grand_total":"678.00","paid_amount":"678.00","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73295","customer_id":"73295","source_of_creation":"PMS","reservation_created_date":"2019-06-18 01:32:50","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3004339","reservation_id":"81411","confirmation_number":"PB12391703821","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"119.00,119.00","nightly_discount":"0.00,0.00","subtotal":"238.00","grand_total":"268.94","paid_amount":"268.94","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89379","customer_id":"89379","source_of_creation":"PMS","reservation_created_date":"2019-07-25 16:44:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007897","reservation_id":"53430","confirmation_number":"PB12356181331","room_stay_from":"2019-08-07","room_stay_to":"2019-08-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,13.27,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1770.00","grand_total":"1985.10","paid_amount":"1985.10","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"39828","customer_id":"39828","source_of_creation":"PMS","reservation_created_date":"2018-08-11 17:48:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008310","reservation_id":"75962","confirmation_number":"PB12347682774","room_stay_from":"2019-08-08","room_stay_to":"2019-08-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.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,75.53,0.00","subtotal":"1610.00","grand_total":"1733.95","paid_amount":"1733.95","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":"28101","customer_id":"28101","source_of_creation":"PMS","reservation_created_date":"2019-05-07 21:55:04","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":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009623","reservation_id":"82385","confirmation_number":"PB12319224589","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"147.00,116.00","nightly_discount":"0.00,0.00","subtotal":"263.00","grand_total":"297.19","paid_amount":"297.19","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90043","customer_id":"90043","source_of_creation":"PMS","reservation_created_date":"2019-08-10 03:00:22","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"147.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3010701","reservation_id":"53441","confirmation_number":"PB12320508866","room_stay_from":"2019-08-08","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"690.00","grand_total":"779.70","paid_amount":"779.70","room_type_id":"289","product_id":"1103","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23536","customer_id":"23536","source_of_creation":"PMS","reservation_created_date":"2018-08-11 19:03:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3013822","reservation_id":"82475","confirmation_number":"PB12318344215","room_stay_from":"2019-08-11","room_stay_to":"2019-08-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.96,76.85,76.85,76.89,76.69","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"398.24","grand_total":"450.01","paid_amount":"450.01","room_type_id":"289","product_id":"1110","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":"90086","customer_id":"90086","source_of_creation":"PMS","reservation_created_date":"2019-08-11 16:29:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3013839","reservation_id":"81438","confirmation_number":"PB12361966034","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.95,76.85","nightly_discount":"0.00,0.00","subtotal":"167.80","grand_total":"189.62","paid_amount":"189.62","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89397","customer_id":"89397","source_of_creation":"PMS","reservation_created_date":"2019-07-25 22:53:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"76.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":"3013897","reservation_id":"82309","confirmation_number":"PB12384117372","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.85,76.85","nightly_discount":"0.00,0.00","subtotal":"153.70","grand_total":"173.68","paid_amount":"173.68","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":"90003","customer_id":"90003","source_of_creation":"PMS","reservation_created_date":"2019-08-09 15:11:45","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":"76.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2996506","reservation_id":"79300","confirmation_number":"PB12220751715","room_confirmation_number":"PB12355711020","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"40.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"87944","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-07-08 17:35:50","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87944","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":"3004340","reservation_id":"81411","confirmation_number":"PB12288788975","room_confirmation_number":"PB12391703821","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"89379","product_attribute_values":"extra_person# ","reservation_created_date":"2019-07-28 20:56:26","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89379","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3005616","reservation_id":"81841","confirmation_number":"PB12293589697","room_confirmation_number":"PB12336427857","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"89682","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-08-01 19:42:11","reservation_modified_date_time":"2019-08-01 19:42:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89682","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":"3009068","reservation_id":"82385","confirmation_number":"PB12280693563","room_confirmation_number":"PB12319224589","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"90043","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-08-10 03:00:22","reservation_modified_date_time":"2019-08-10 03:00:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90043","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":"3009575","reservation_id":"79286","confirmation_number":"PB12212882804","room_confirmation_number":"PB12389725674","room_stay_from":"2019-08-07","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"40,40,40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"240.00","grand_total":"271.20","paid_amount":"271.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"87934","product_attribute_values":"extra_person# ","reservation_created_date":"2019-08-11 18:50:19","reservation_modified_date_time":"2019-08-11 18:50:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87934","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"160.00","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":"3009582","reservation_id":"81751","confirmation_number":"PB12229712515","room_confirmation_number":"PB12339098834","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"89617","product_attribute_values":"extra_person# ","reservation_created_date":"2019-08-11 19:11:08","reservation_modified_date_time":"2019-08-11 19:11:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89617","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":"2920756","reservation_id":"67457","confirmation_number":"PB12247933860","room_confirmation_number":"PB12319499413","room_stay_from":"2019-08-05","room_stay_to":"2019-08-07","room_stay_status":"Canceled","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-21 07:33:13","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80668","parentCustTravId":"80668","customer_traveller_id":"80668","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-08-11 18:09:20","canceled_nights_data":"","product_attribute_values":"extra_person# .00","deltaChange":-60,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2962780","reservation_id":"74034","confirmation_number":"PB12268689583","room_confirmation_number":"PB12348835370","room_stay_from":"2019-08-08","room_stay_to":"2019-08-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":"84616","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-04 18:07:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84616","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":"2979087","reservation_id":"53432","confirmation_number":"PB12347834991","room_confirmation_number":"PB12374646801","room_stay_from":"2019-08-06","room_stay_to":"2019-08-22","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.00,0.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23537","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-08-11 17:56:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23537","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2987116","reservation_id":"78489","confirmation_number":"PB12253520977","room_confirmation_number":"PB12389442012","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"1781","service_quantity":"1","customer_traveller_id":"87541","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-11 21:06:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87541","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":"2989305","reservation_id":"54228","confirmation_number":"PBR12282947756","room_confirmation_number":"PB12320020546","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"73295","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73295","canceled_nights_data":"","currentDayPrice":"12.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":"2989309","reservation_id":"78883","confirmation_number":"PB12249264700","room_confirmation_number":"PB12347855915","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","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":"73295","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-18 01:32:50","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73295","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":"2990399","reservation_id":"79337","confirmation_number":"PB12246053798","room_confirmation_number":"PB12388297548","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","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":"87969","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-21 16:52:04","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73295","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":"2991510","reservation_id":"79517","confirmation_number":"PB12270064922","room_confirmation_number":"PB12360497460","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","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":"88081","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-24 15:25:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88081","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":"2991512","reservation_id":"79513","confirmation_number":"PB12261262738","room_confirmation_number":"PB12315933154","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","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":"88077","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-24 14:07:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72925","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":"2993061","reservation_id":"79794","confirmation_number":"PB12214775527","room_confirmation_number":"PB12380957904","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"88291","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-28 18:07:56","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88291","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":"2996505","reservation_id":"79300","confirmation_number":"PB12283384258","room_confirmation_number":"PB12355711020","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","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":"87944","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-20 21:05:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87944","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":"2997313","reservation_id":"79643","confirmation_number":"PB12295678341","room_confirmation_number":"PB12382874275","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"1781","service_quantity":"1","customer_traveller_id":"88184","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-26 18:44: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":"88184","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":"3003834","reservation_id":"81552","confirmation_number":"PB12234926632","room_confirmation_number":"PB12370869808","room_stay_from":"2019-08-10","room_stay_to":"2019-08-16","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":"89450","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-27 17:09:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89450","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":"3004341","reservation_id":"81411","confirmation_number":"PB12280021228","room_confirmation_number":"PB12391703821","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"89379","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-25 16:44:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89379","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":"3004351","reservation_id":"79794","confirmation_number":"PB12223354221","room_confirmation_number":"PB12378389803","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"88291","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-28 18:07:57","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88291","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":"3005617","reservation_id":"81841","confirmation_number":"PB12296382351","room_confirmation_number":"PB12336427857","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","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":"89682","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-01 19:42:11","reservation_modified_date_time":"2019-08-01 19:42:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89682","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":"3007898","reservation_id":"53430","confirmation_number":"PB12369542379","room_confirmation_number":"PB12356181331","room_stay_from":"2019-08-07","room_stay_to":"2019-08-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","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":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"39828","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-08-11 17:48:14","reservation_modified_date_time":"2019-08-07 16:07:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"39828","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":"3008311","reservation_id":"75962","confirmation_number":"PB12277105280","room_confirmation_number":"PB12347682774","room_stay_from":"2019-08-08","room_stay_to":"2019-08-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"28101","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-05-07 21:55:04","reservation_modified_date_time":"2019-08-08 14:43:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28101","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":"3008775","reservation_id":"82316","confirmation_number":"PB12216146692","room_confirmation_number":"PB12341200209","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","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":"90009","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-09 16:03:13","reservation_modified_date_time":"2019-08-09 16:03:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73295","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":"3009578","reservation_id":"79286","confirmation_number":"PB12288310511","room_confirmation_number":"PB12389725674","room_stay_from":"2019-08-07","room_stay_to":"2019-08-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":"87934","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-20 18:15:10","reservation_modified_date_time":"2019-08-11 18:54:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87934","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":"3009612","reservation_id":"81751","confirmation_number":"PB12218152788","room_confirmation_number":"PB12339098834","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","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":"89617","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-31 14:48:08","reservation_modified_date_time":"2019-08-11 20:41:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89617","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":"3009624","reservation_id":"82385","confirmation_number":"PB12211559380","room_confirmation_number":"PB12319224589","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","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":"90043","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-10 03:00:22","reservation_modified_date_time":"2019-08-11 21:15:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90043","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":"3010702","reservation_id":"53441","confirmation_number":"PB12399452323","room_confirmation_number":"PB12320508866","room_stay_from":"2019-08-08","room_stay_to":"2019-08-15","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":"23536","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-08-11 19:03:12","reservation_modified_date_time":"2019-08-15 15:15:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23536","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":"3013823","reservation_id":"82475","confirmation_number":"PB12298678386","room_confirmation_number":"PB12318344215","room_stay_from":"2019-08-11","room_stay_to":"2019-08-16","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"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":"90086","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-11 16:29:20","reservation_modified_date_time":"2019-08-25 20:53:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90086","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":"3013840","reservation_id":"81438","confirmation_number":"PB12235054218","room_confirmation_number":"PB12361966034","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89397","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-25 22:53:33","reservation_modified_date_time":"2019-08-25 21:00:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89397","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":[],"gift_shop_taxable":[{"room_stay_id":"3009493","reservation_id":"81552","confirmation_number":"PB12262216698","room_confirmation_number":"PB12370869808","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":"2019-08-11 13:14:10","reservation_modified_date_time":"2019-08-11 13:14:10","customer_id":"89450","parentCustTravId":"89450","customer_traveller_id":"89450","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":"3009494","reservation_id":"81552","confirmation_number":"PB12244644466","room_confirmation_number":"PB12370869808","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":"2019-08-11 13:14:10","reservation_modified_date_time":"2019-08-11 13:14:10","customer_id":"89450","parentCustTravId":"89450","customer_traveller_id":"89450","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":"3009519","reservation_id":"82471","confirmation_number":"PB12263718885","room_confirmation_number":"PB12380508806","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 15:46:35","reservation_modified_date_time":"2019-08-11 15:46:35","customer_id":"90081","parentCustTravId":"90081","customer_traveller_id":"90081","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009544","reservation_id":"82475","confirmation_number":"PB12288882351","room_confirmation_number":"PB12318344215","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1217","service_quantity":"5","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 16:29:46","reservation_modified_date_time":"2019-08-11 16:29:46","customer_id":"90086","parentCustTravId":"90086","customer_traveller_id":"90086","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009620","reservation_id":"81438","confirmation_number":"PB12279778899","room_confirmation_number":"PB12361966034","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1156","service_quantity":"2","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 02:34:29","reservation_modified_date_time":"2019-08-11 21:10:31","customer_id":"89397","parentCustTravId":"89397","customer_traveller_id":"89397","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","changedComment":"price, discount or quantity changed","deltaChange":"25.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009636","reservation_id":"82488","confirmation_number":"PB12258371685","room_confirmation_number":"PB12345179193","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 21:33:53","reservation_modified_date_time":"2019-08-11 21:33:53","customer_id":"90098","parentCustTravId":"90098","customer_traveller_id":"90098","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009722","reservation_id":"82494","confirmation_number":"PB12216352003","room_confirmation_number":"PB12329121780","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 22:53:46","reservation_modified_date_time":"2019-08-11 22:53:46","customer_id":"90105","parentCustTravId":"90105","customer_traveller_id":"90105","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009746","reservation_id":"82501","confirmation_number":"PB12297944909","room_confirmation_number":"PB12320380057","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-12 00:47:24","reservation_modified_date_time":"2019-08-12 00:47:24","customer_id":"90112","parentCustTravId":"90112","customer_traveller_id":"90112","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3005185","reservation_id":"81765","confirmation_number":"PB12249662462","room_confirmation_number":"PB12323643994","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-31 18:46:41","reservation_modified_date_time":"2019-07-31 18:46:41","customer_id":"89630","parentCustTravId":"89630","customer_traveller_id":"89630","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-08-11 19:30:07","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-40,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.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":6,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"htn_taxable":[{"room_stay_id":"3006438","reservation_id":"81952","confirmation_number":"BV12416452213","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.66,101.66,70.11","nightly_discount":"0,0,0","subtotal":"273.43","grand_total":"308.98","paid_amount":"308.98","room_type_id":"303","product_id":"1139","siteminder_id":"HTN-94404576-LJX29X","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":"89750","customer_id":"89750","source_of_creation":"HotelTonight","reservation_created_date":"2019-08-03 17:55:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.11","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":"3009734","reservation_id":"82496","confirmation_number":"BV12463573036","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.66,41.33,49.36","nightly_discount":"0,0,0","subtotal":"142.35","grand_total":"160.85","paid_amount":"160.85","room_type_id":"304","product_id":"1219","siteminder_id":"HTN-95544153-94YCW4","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":"90107","customer_id":"90107","source_of_creation":"HotelTonight","reservation_created_date":"2019-08-11 23:38:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"51.66","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3009579","reservation_id":"82479","confirmation_number":"BV12415480155","room_stay_from":"2019-08-11","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"103.79","nightly_discount":"0","subtotal":"103.79","grand_total":"135.42","paid_amount":"135.42","room_type_id":"309","product_id":"1226","siteminder_id":"ABB-HMACKJNDPX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"103.79","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90090","customer_id":"90090","source_of_creation":"Airbnb","reservation_created_date":"2019-08-11 19:07:04","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"14.51","commision_charges":"3.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.79","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3002957","reservation_id":"81423","confirmation_number":"BV12494953852","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"144.20,101.09,80.87","nightly_discount":"0.00,0.00,0.00","subtotal":"326.16","grand_total":"368.56","paid_amount":"368.56","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89391","customer_id":"89391","source_of_creation":"FE","reservation_created_date":"2019-07-25 19:50:07","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"101.09","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3005297","reservation_id":"78030","confirmation_number":"BV12485808845","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.50,113.72,90.98","nightly_discount":"0.00,0.00,0.00","subtotal":"376.20","grand_total":"425.10","paid_amount":"425.10","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":"87223","customer_id":"87223","source_of_creation":"FE","reservation_created_date":"2019-06-05 16:45:41","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":"","currentDayPrice":"113.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008155","reservation_id":"82180","confirmation_number":"BV12425343611","room_stay_from":"2019-08-10","room_stay_to":"2019-08-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.40,100.31,80.24,80.24","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"416.19","grand_total":"470.29","paid_amount":"470.29","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":"89875","customer_id":"89875","source_of_creation":"FE","reservation_created_date":"2019-08-07 14:36:49","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":"","currentDayPrice":"100.31","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008488","reservation_id":"69614","confirmation_number":"BV12440003514","room_stay_from":"2019-08-08","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"162.00,212.00,212.00,162.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"748.00","grand_total":"845.24","paid_amount":"845.24","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81963","customer_id":"81963","source_of_creation":"FE","reservation_created_date":"2019-02-16 21:04:23","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"162.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2986571","reservation_id":"77828","confirmation_number":"BV12461603372","room_stay_from":"2019-08-10","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.30,114.48,91.58,91.58,91.58,91.58,117.04","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"744.14","grand_total":"840.88","paid_amount":"840.88","room_type_id":"294","product_id":"1126","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":"87052","customer_id":"87052","source_of_creation":"PMS","reservation_created_date":"2019-06-02 17:09:18","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008553","reservation_id":"81651","confirmation_number":"BV12464034907","room_stay_from":"2019-08-04","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.73,90.73,90.73,90.73,90.73,136.30,136.30,95.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,31.99,4.75,0.00","subtotal":"821.25","grand_total":"886.50","paid_amount":"886.50","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"35292","customer_id":"35292","source_of_creation":"PMS","reservation_created_date":"2019-07-29 14:14:59","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":"95.00","currentDayDiscount":"4.75","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009553","reservation_id":"82406","confirmation_number":"BV12419288376","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.63,104.51","nightly_discount":"0.00,6.43,0.00","subtotal":"235.14","grand_total":"258.44","paid_amount":"258.44","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":"56194","customer_id":"56194","source_of_creation":"PMS","reservation_created_date":"2019-08-10 16:39:49","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":"130.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009750","reservation_id":"82503","confirmation_number":"BV12447741952","room_stay_from":"2019-08-11","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.97","nightly_discount":"0.00","subtotal":"97.97","grand_total":"110.71","paid_amount":"110.71","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90114","customer_id":"90114","source_of_creation":"PMS","reservation_created_date":"2019-08-12 01:14:56","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":"97.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3002959","reservation_id":"81423","confirmation_number":"BV12250526782","room_confirmation_number":"BV12494953852","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"89391","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-07-25 19:50:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89391","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008490","reservation_id":"69614","confirmation_number":"BV12243547821","room_confirmation_number":"BV12440003514","room_stay_from":"2019-08-08","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"81963","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-08-08 20:30:32","reservation_modified_date_time":"2019-08-08 20:30:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81963","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2986572","reservation_id":"77828","confirmation_number":"BV12265679985","room_confirmation_number":"BV12461603372","room_stay_from":"2019-08-10","room_stay_to":"2019-08-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"87052","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-02 17:09:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87052","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":"3002958","reservation_id":"81423","confirmation_number":"BV12271472695","room_confirmation_number":"BV12494953852","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"89391","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-25 19:50:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89391","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":"3005298","reservation_id":"78030","confirmation_number":"BV12250998352","room_confirmation_number":"BV12485808845","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"87223","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-05 16:45:41","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87223","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":"3006439","reservation_id":"81952","confirmation_number":"BV12210040751","room_confirmation_number":"BV12416452213","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"1781","service_quantity":"1","customer_traveller_id":"89750","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-03 17:55:11","reservation_modified_date_time":"2019-08-03 17:55:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89750","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":"3008156","reservation_id":"82180","confirmation_number":"BV12254881315","room_confirmation_number":"BV12425343611","room_stay_from":"2019-08-10","room_stay_to":"2019-08-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"89875","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-07 14:36:49","reservation_modified_date_time":"2019-08-07 14:36:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89875","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":"3008491","reservation_id":"69614","confirmation_number":"BV12299483730","room_confirmation_number":"BV12440003514","room_stay_from":"2019-08-08","room_stay_to":"2019-08-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":"81964","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-02-16 21:04:23","reservation_modified_date_time":"2019-08-08 20:30:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81963","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":"3008554","reservation_id":"81651","confirmation_number":"BV12248202915","room_confirmation_number":"BV12464034907","room_stay_from":"2019-08-04","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"35292","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-29 14:14:59","reservation_modified_date_time":"2019-08-08 22:44:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"35292","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":"3009554","reservation_id":"82406","confirmation_number":"BV12276296403","room_confirmation_number":"BV12419288376","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","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":"56194","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-10 16:39:49","reservation_modified_date_time":"2019-08-11 16:44:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56194","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":"3009580","reservation_id":"82479","confirmation_number":"BV12251147290","room_confirmation_number":"BV12415480155","room_stay_from":"2019-08-11","room_stay_to":"2019-08-12","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":"90090","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-11 19:07:04","reservation_modified_date_time":"2019-08-11 19:07:04","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90090","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3009735","reservation_id":"82496","confirmation_number":"BV12273448469","room_confirmation_number":"BV12463573036","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","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":"90107","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-11 23:38:12","reservation_modified_date_time":"2019-08-11 23:38:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90107","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":"3009751","reservation_id":"82503","confirmation_number":"BV12233293797","room_confirmation_number":"BV12447741952","room_stay_from":"2019-08-11","room_stay_to":"2019-08-12","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":"90114","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-12 01:14:56","reservation_modified_date_time":"2019-08-12 01:14:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90114","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2936598","reservation_id":"69614","confirmation_number":"BV12269680554","room_confirmation_number":"BV12440003514","room_stay_from":"2019-08-08","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 21:53:33","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81963","parentCustTravId":"81963","customer_traveller_id":"81964","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":"2983706","reservation_id":"77828","confirmation_number":"BV12211984930","room_confirmation_number":"BV12461603372","room_stay_from":"2019-08-10","room_stay_to":"2019-08-17","room_stay_status":"Active","nightly_price":"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","subtotal":"175.00","grand_total":"197.75","paid_amount":"197.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-02 17:09:18","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87052","parentCustTravId":"87052","customer_traveller_id":"87052","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":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":2,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3009729","reservation_id":"80777","confirmation_number":"BP12515026195","room_stay_from":"2019-08-11","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"92.24,71.79,71.79,71.79,71.79,93.12","nightly_discount":"0,0,0,0,0,0","subtotal":"472.52","grand_total":"533.95","paid_amount":"533.95","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1300503450","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88959","customer_id":"88959","source_of_creation":"Expedia","reservation_created_date":"2019-07-15 18:10:09","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":"92.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2920753","reservation_id":"67456","confirmation_number":"BP12593388772","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.16,56.16,56.16","nightly_discount":"0,0,0","subtotal":"168.48","grand_total":"190.38","paid_amount":"63.46","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1183161047","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":"80667","customer_id":"80667","source_of_creation":"Expedia","reservation_created_date":"2019-01-21 07:29:12","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":56.16,"currentDayDiscount":0,"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"}]}],"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3004386","reservation_id":"81632","confirmation_number":"BP12527736744","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.93,94.96,94.96,64.93,51.95","nightly_discount":"0,0,0,0,0","subtotal":"371.73","grand_total":"420.05","paid_amount":"420.05","room_type_id":"293","product_id":"1124","siteminder_id":"GAM-R1591644405","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":"72474","customer_id":"72474","source_of_creation":"Getaroom.com","reservation_created_date":"2019-07-28 22:39:08","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2984191","reservation_id":"77933","confirmation_number":"BP12593583781","room_stay_from":"2019-08-11","room_stay_to":"2019-08-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.60,103.68,103.68,103.68,103.68,128.80,128.80,103.68,103.68,103.68,103.68,103.68,128.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1449.12","grand_total":"1637.51","paid_amount":"1637.51","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87132","customer_id":"87132","source_of_creation":"PMS","reservation_created_date":"2019-06-04 02:44:56","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007861","reservation_id":"80896","confirmation_number":"BP12558542356","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"500.00","grand_total":"565.00","paid_amount":"565.00","room_type_id":"295","product_id":"1128","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89053","customer_id":"89053","source_of_creation":"PMS","reservation_created_date":"2019-07-17 23:05:54","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008025","reservation_id":"82196","confirmation_number":"BP12577320649","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"159.21,127.37,127.37","nightly_discount":"0.00,0.00,0.00","subtotal":"413.95","grand_total":"467.77","paid_amount":"467.77","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":"50113","customer_id":"50113","source_of_creation":"PMS","reservation_created_date":"2019-08-07 19:46:02","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":"159.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008573","reservation_id":"79394","confirmation_number":"BP12524781693","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"188.73,188.73,198.10,198.10,188.73","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"962.39","grand_total":"1087.50","paid_amount":"1087.50","room_type_id":"288","product_id":"1092","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88006","customer_id":"88006","source_of_creation":"PMS","reservation_created_date":"2019-06-22 17:55:00","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3008027","reservation_id":"82196","confirmation_number":"BP12240916194","room_confirmation_number":"BP12577320649","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"50113","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-08-07 19:46:02","reservation_modified_date_time":"2019-08-07 19:46:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50113","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008574","reservation_id":"79394","confirmation_number":"BP12249637621","room_confirmation_number":"BP12524781693","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"88006","product_attribute_values":"extra_person# ","reservation_created_date":"2019-08-09 00:19:24","reservation_modified_date_time":"2019-08-09 00:19:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88006","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009730","reservation_id":"80777","confirmation_number":"BP12263125816","room_confirmation_number":"BP12515026195","room_stay_from":"2019-08-11","room_stay_to":"2019-08-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,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":"88959","product_attribute_values":"extra_person# ","reservation_created_date":"2019-08-11 23:17:19","reservation_modified_date_time":"2019-08-11 23:17:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88959","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2920754","reservation_id":"67456","confirmation_number":"BP12272042708","room_confirmation_number":"BP12593388772","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","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":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-21 07:29:12","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80667","parentCustTravId":"80667","customer_traveller_id":"80667","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#","currentDayPrice":20,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2984193","reservation_id":"77933","confirmation_number":"BP12251920288","room_confirmation_number":"BP12593583781","room_stay_from":"2019-08-11","room_stay_to":"2019-08-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"87132","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-04 02:44:56","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87132","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":"3004387","reservation_id":"81632","confirmation_number":"BP12255101365","room_confirmation_number":"BP12527736744","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","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":"89505","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-28 22:39:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72474","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":"3007862","reservation_id":"80896","confirmation_number":"BP12268068460","room_confirmation_number":"BP12558542356","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","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":"89053","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-17 23:05:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89053","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":"3008028","reservation_id":"82196","confirmation_number":"BP12221168488","room_confirmation_number":"BP12577320649","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","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":"50113","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-07 19:46:02","reservation_modified_date_time":"2019-08-07 19:46:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50113","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":"3008575","reservation_id":"79394","confirmation_number":"BP12288144832","room_confirmation_number":"BP12524781693","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","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":"88006","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-22 17:55:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88006","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":"3009731","reservation_id":"80777","confirmation_number":"BP12299977414","room_confirmation_number":"BP12515026195","room_stay_from":"2019-08-11","room_stay_to":"2019-08-17","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":"88959","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-15 18:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88959","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2984192","reservation_id":"77933","confirmation_number":"BP12271466401","room_confirmation_number":"BP12593583781","room_stay_from":"2019-08-11","room_stay_to":"2019-08-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"367.25","paid_amount":"367.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-04 02:44:56","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87132","parentCustTravId":"87132","customer_traveller_id":"87132","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":"3008026","reservation_id":"82196","confirmation_number":"BP12234689104","room_confirmation_number":"BP12577320649","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-07 19:46:02","reservation_modified_date_time":"2019-08-07 19:46:02","customer_id":"50113","parentCustTravId":"50113","customer_traveller_id":"50113","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":[]}},"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-08-11","total_rooms_exist":66,"departureCount":31,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"2","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3009611","reservation_id":"81751","confirmation_number":"PB12339098834","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"4","nightly_price":"160.25,128.05,128.05,128.05","nightly_discount":"0.00,0.00,0.00,33.01,0.00","subtotal":"544.40","grand_total":"577.87","paid_amount":"577.87","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-3482870974","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89617","customer_id":"89617","source_of_creation":"Booking.com","reservation_created_date":"2019-07-31 14:48:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"99.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2987115","reservation_id":"78489","confirmation_number":"PB12389442012","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.76,102.76,99.92","nightly_discount":"0,0,0","subtotal":"305.44","grand_total":"345.15","paid_amount":"345.15","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1276009003","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":"87541","customer_id":"87541","source_of_creation":"Expedia","reservation_created_date":"2019-06-11 21:06:08","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":"99.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":"2991509","reservation_id":"79517","confirmation_number":"PB12360497460","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.62,118.90","nightly_discount":"0,0","subtotal":"267.52","grand_total":"302.30","paid_amount":"302.30","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1284904201","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":"88081","customer_id":"88081","source_of_creation":"Expedia","reservation_created_date":"2019-06-24 15:25:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"148.62","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":"2996504","reservation_id":"79300","confirmation_number":"PB12355711020","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"174.64,174.64,175.35,140.28,140.28","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"805.19","grand_total":"909.86","paid_amount":"909.86","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1282460344","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":"87944","customer_id":"87944","source_of_creation":"Expedia","reservation_created_date":"2019-06-20 21:05:10","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":"140.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2997312","reservation_id":"79643","confirmation_number":"PB12382874275","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.16,164.16,161.00","nightly_discount":"0,0,0","subtotal":"489.32","grand_total":"552.93","paid_amount":"552.93","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1286634874","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":"88184","customer_id":"88184","source_of_creation":"Expedia","reservation_created_date":"2019-06-26 18:44:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.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":"3003833","reservation_id":"81552","confirmation_number":"PB12370869808","room_stay_from":"2019-08-10","room_stay_to":"2019-08-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.62,132.02,105.62,105.62,105.62,105.62","nightly_discount":"0,0,0,0,0,0","subtotal":"689.12","grand_total":"778.71","paid_amount":"778.71","room_type_id":"289","product_id":"1109","siteminder_id":"EXP-1309325006","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":"89450","customer_id":"89450","source_of_creation":"Expedia","reservation_created_date":"2019-07-27 17:09:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3005615","reservation_id":"81841","confirmation_number":"PB12336427857","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"104.46,80.09,80.09,80.09","nightly_discount":"0,0,0,0","subtotal":"344.73","grand_total":"389.54","paid_amount":"389.54","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1312998522","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89682","customer_id":"89682","source_of_creation":"Expedia","reservation_created_date":"2019-08-01 19:42:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.46","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009577","reservation_id":"79286","confirmation_number":"PB12389725674","room_stay_from":"2019-08-07","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"151.39,151.39,148.50,148.50,151.39,141.39","nightly_discount":"0.00,45.00,0.00,0.00,0.00,0.00","subtotal":"892.56","grand_total":"957.74","paid_amount":"957.74","room_type_id":"288","product_id":"1091","siteminder_id":"EXP-1282352394","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"240.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87934","customer_id":"87934","source_of_creation":"Expedia","reservation_created_date":"2019-06-20 18:15:10","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"151.39","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009729","reservation_id":"80777","confirmation_number":"BP12515026195","room_stay_from":"2019-08-11","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"92.24,71.79,71.79,71.79,71.79,93.12","nightly_discount":"0,0,0,0,0,0","subtotal":"472.52","grand_total":"533.95","paid_amount":"533.95","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1300503450","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88959","customer_id":"88959","source_of_creation":"Expedia","reservation_created_date":"2019-07-15 18:10:09","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":"92.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2920753","reservation_id":"67456","confirmation_number":"BP12593388772","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.16,56.16,56.16","nightly_discount":"0,0,0","subtotal":"168.48","grand_total":"190.38","paid_amount":"63.46","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1183161047","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":"80667","customer_id":"80667","source_of_creation":"Expedia","reservation_created_date":"2019-01-21 07:29:12","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":56.16,"currentDayDiscount":0,"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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2990398","reservation_id":"79337","confirmation_number":"PB12388297548","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.23,49.02,38.97,38.97,38.97","nightly_discount":"0,0,0,0,0","subtotal":"216.16","grand_total":"244.26","paid_amount":"244.26","room_type_id":"285","product_id":"1083","siteminder_id":"HTN-88883820-GCY3YQ","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":"73295","customer_id":"73295","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-21 16:52:04","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":"49.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2991511","reservation_id":"79513","confirmation_number":"PB12315933154","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.02,38.97","nightly_discount":"0,0","subtotal":"87.99","grand_total":"99.43","paid_amount":"99.43","room_type_id":"285","product_id":"1085","siteminder_id":"HTN-89214162-Q392FV","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":"72925","customer_id":"72925","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-24 14:07:08","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":"49.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3006438","reservation_id":"81952","confirmation_number":"BV12416452213","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.66,101.66,70.11","nightly_discount":"0,0,0","subtotal":"273.43","grand_total":"308.98","paid_amount":"308.98","room_type_id":"303","product_id":"1139","siteminder_id":"HTN-94404576-LJX29X","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":"89750","customer_id":"89750","source_of_creation":"HotelTonight","reservation_created_date":"2019-08-03 17:55:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.11","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":"3008774","reservation_id":"82316","confirmation_number":"PB12341200209","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.17,54.24,66.64,85.99","nightly_discount":"0,0,0,0","subtotal":"290.04","grand_total":"327.74","paid_amount":"327.74","room_type_id":"292","product_id":"1120","siteminder_id":"HTN-95186185-LQ92PM","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":"73295","customer_id":"73295","source_of_creation":"HotelTonight","reservation_created_date":"2019-08-09 16:03:13","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":"83.17","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":"3009734","reservation_id":"82496","confirmation_number":"BV12463573036","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.66,41.33,49.36","nightly_discount":"0,0,0","subtotal":"142.35","grand_total":"160.85","paid_amount":"160.85","room_type_id":"304","product_id":"1219","siteminder_id":"HTN-95544153-94YCW4","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":"90107","customer_id":"90107","source_of_creation":"HotelTonight","reservation_created_date":"2019-08-11 23:38:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"51.66","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3004386","reservation_id":"81632","confirmation_number":"BP12527736744","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.93,94.96,94.96,64.93,51.95","nightly_discount":"0,0,0,0,0","subtotal":"371.73","grand_total":"420.05","paid_amount":"420.05","room_type_id":"293","product_id":"1124","siteminder_id":"GAM-R1591644405","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":"72474","customer_id":"72474","source_of_creation":"Getaroom.com","reservation_created_date":"2019-07-28 22:39:08","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3009579","reservation_id":"82479","confirmation_number":"BV12415480155","room_stay_from":"2019-08-11","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"103.79","nightly_discount":"0","subtotal":"103.79","grand_total":"135.42","paid_amount":"135.42","room_type_id":"309","product_id":"1226","siteminder_id":"ABB-HMACKJNDPX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"103.79","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90090","customer_id":"90090","source_of_creation":"Airbnb","reservation_created_date":"2019-08-11 19:07:04","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"14.51","commision_charges":"3.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.79","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2993060","reservation_id":"79794","confirmation_number":"PB12380957904","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.70,161.70,146.61","nightly_discount":"0.00,0.00,17.76,0.00","subtotal":"470.01","grand_total":"511.05","paid_amount":"511.05","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":"88291","customer_id":"88291","source_of_creation":"FE","reservation_created_date":"2019-06-28 18:07:56","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":"146.61","currentDayDiscount":"17.76","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002957","reservation_id":"81423","confirmation_number":"BV12494953852","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"144.20,101.09,80.87","nightly_discount":"0.00,0.00,0.00","subtotal":"326.16","grand_total":"368.56","paid_amount":"368.56","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89391","customer_id":"89391","source_of_creation":"FE","reservation_created_date":"2019-07-25 19:50:07","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"101.09","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3004350","reservation_id":"79794","confirmation_number":"PB12378389803","room_stay_from":"2019-08-09","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.70,161.70,146.61","nightly_discount":"0.00,0.00,17.76","subtotal":"470.01","grand_total":"511.05","paid_amount":"511.05","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88291","customer_id":"88291","source_of_creation":"FE","reservation_created_date":"2019-06-28 18:07:56","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":"146.61","currentDayDiscount":"17.76","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3005297","reservation_id":"78030","confirmation_number":"BV12485808845","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.50,113.72,90.98","nightly_discount":"0.00,0.00,0.00","subtotal":"376.20","grand_total":"425.10","paid_amount":"425.10","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":"87223","customer_id":"87223","source_of_creation":"FE","reservation_created_date":"2019-06-05 16:45:41","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":"","currentDayPrice":"113.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008155","reservation_id":"82180","confirmation_number":"BV12425343611","room_stay_from":"2019-08-10","room_stay_to":"2019-08-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.40,100.31,80.24,80.24","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"416.19","grand_total":"470.29","paid_amount":"470.29","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":"89875","customer_id":"89875","source_of_creation":"FE","reservation_created_date":"2019-08-07 14:36:49","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":"","currentDayPrice":"100.31","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008488","reservation_id":"69614","confirmation_number":"BV12440003514","room_stay_from":"2019-08-08","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"162.00,212.00,212.00,162.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"748.00","grand_total":"845.24","paid_amount":"845.24","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81963","customer_id":"81963","source_of_creation":"FE","reservation_created_date":"2019-02-16 21:04:23","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"162.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2962779","reservation_id":"74034","confirmation_number":"PB12348835370","room_stay_from":"2019-08-08","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.00,316.00,316.00,266.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1164.00","grand_total":"1315.32","paid_amount":"1315.32","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":"84616","customer_id":"84616","source_of_creation":"PMS","reservation_created_date":"2019-04-04 18:07:20","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":"266.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2979086","reservation_id":"53432","confirmation_number":"PB12374646801","room_stay_from":"2019-08-06","room_stay_to":"2019-08-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.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","subtotal":"1888.00","grand_total":"2133.44","paid_amount":"2133.44","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23537","customer_id":"23537","source_of_creation":"PMS","reservation_created_date":"2018-08-11 17:56:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2984191","reservation_id":"77933","confirmation_number":"BP12593583781","room_stay_from":"2019-08-11","room_stay_to":"2019-08-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.60,103.68,103.68,103.68,103.68,128.80,128.80,103.68,103.68,103.68,103.68,103.68,128.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1449.12","grand_total":"1637.51","paid_amount":"1637.51","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87132","customer_id":"87132","source_of_creation":"PMS","reservation_created_date":"2019-06-04 02:44:56","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986571","reservation_id":"77828","confirmation_number":"BV12461603372","room_stay_from":"2019-08-10","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.30,114.48,91.58,91.58,91.58,91.58,117.04","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"744.14","grand_total":"840.88","paid_amount":"840.88","room_type_id":"294","product_id":"1126","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":"87052","customer_id":"87052","source_of_creation":"PMS","reservation_created_date":"2019-06-02 17:09:18","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2989304","reservation_id":"54228","confirmation_number":"PB12320020546","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"600.00","grand_total":"678.00","paid_amount":"678.00","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":"73295","customer_id":"73295","source_of_creation":"PMS","reservation_created_date":"2018-08-23 00:48:22","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2989308","reservation_id":"78883","confirmation_number":"PB12347855915","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"600.00","grand_total":"678.00","paid_amount":"678.00","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73295","customer_id":"73295","source_of_creation":"PMS","reservation_created_date":"2019-06-18 01:32:50","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3004339","reservation_id":"81411","confirmation_number":"PB12391703821","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"119.00,119.00","nightly_discount":"0.00,0.00","subtotal":"238.00","grand_total":"268.94","paid_amount":"268.94","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89379","customer_id":"89379","source_of_creation":"PMS","reservation_created_date":"2019-07-25 16:44:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007861","reservation_id":"80896","confirmation_number":"BP12558542356","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"500.00","grand_total":"565.00","paid_amount":"565.00","room_type_id":"295","product_id":"1128","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89053","customer_id":"89053","source_of_creation":"PMS","reservation_created_date":"2019-07-17 23:05:54","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007897","reservation_id":"53430","confirmation_number":"PB12356181331","room_stay_from":"2019-08-07","room_stay_to":"2019-08-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,13.27,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1770.00","grand_total":"1985.10","paid_amount":"1985.10","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"39828","customer_id":"39828","source_of_creation":"PMS","reservation_created_date":"2018-08-11 17:48:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008025","reservation_id":"82196","confirmation_number":"BP12577320649","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"159.21,127.37,127.37","nightly_discount":"0.00,0.00,0.00","subtotal":"413.95","grand_total":"467.77","paid_amount":"467.77","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":"50113","customer_id":"50113","source_of_creation":"PMS","reservation_created_date":"2019-08-07 19:46:02","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":"159.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008310","reservation_id":"75962","confirmation_number":"PB12347682774","room_stay_from":"2019-08-08","room_stay_to":"2019-08-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.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,75.53,0.00","subtotal":"1610.00","grand_total":"1733.95","paid_amount":"1733.95","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":"28101","customer_id":"28101","source_of_creation":"PMS","reservation_created_date":"2019-05-07 21:55:04","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":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008553","reservation_id":"81651","confirmation_number":"BV12464034907","room_stay_from":"2019-08-04","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.73,90.73,90.73,90.73,90.73,136.30,136.30,95.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,31.99,4.75,0.00","subtotal":"821.25","grand_total":"886.50","paid_amount":"886.50","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"35292","customer_id":"35292","source_of_creation":"PMS","reservation_created_date":"2019-07-29 14:14:59","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":"95.00","currentDayDiscount":"4.75","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008573","reservation_id":"79394","confirmation_number":"BP12524781693","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"188.73,188.73,198.10,198.10,188.73","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"962.39","grand_total":"1087.50","paid_amount":"1087.50","room_type_id":"288","product_id":"1092","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88006","customer_id":"88006","source_of_creation":"PMS","reservation_created_date":"2019-06-22 17:55:00","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009553","reservation_id":"82406","confirmation_number":"BV12419288376","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.63,104.51","nightly_discount":"0.00,6.43,0.00","subtotal":"235.14","grand_total":"258.44","paid_amount":"258.44","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":"56194","customer_id":"56194","source_of_creation":"PMS","reservation_created_date":"2019-08-10 16:39:49","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":"130.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009623","reservation_id":"82385","confirmation_number":"PB12319224589","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"147.00,116.00","nightly_discount":"0.00,0.00","subtotal":"263.00","grand_total":"297.19","paid_amount":"297.19","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90043","customer_id":"90043","source_of_creation":"PMS","reservation_created_date":"2019-08-10 03:00:22","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"147.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009750","reservation_id":"82503","confirmation_number":"BV12447741952","room_stay_from":"2019-08-11","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.97","nightly_discount":"0.00","subtotal":"97.97","grand_total":"110.71","paid_amount":"110.71","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90114","customer_id":"90114","source_of_creation":"PMS","reservation_created_date":"2019-08-12 01:14:56","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":"97.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3010701","reservation_id":"53441","confirmation_number":"PB12320508866","room_stay_from":"2019-08-08","room_stay_to":"2019-08-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"690.00","grand_total":"779.70","paid_amount":"779.70","room_type_id":"289","product_id":"1103","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23536","customer_id":"23536","source_of_creation":"PMS","reservation_created_date":"2018-08-11 19:03:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3013822","reservation_id":"82475","confirmation_number":"PB12318344215","room_stay_from":"2019-08-11","room_stay_to":"2019-08-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.96,76.85,76.85,76.89,76.69","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"398.24","grand_total":"450.01","paid_amount":"450.01","room_type_id":"289","product_id":"1110","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":"90086","customer_id":"90086","source_of_creation":"PMS","reservation_created_date":"2019-08-11 16:29:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3013839","reservation_id":"81438","confirmation_number":"PB12361966034","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.95,76.85","nightly_discount":"0.00,0.00","subtotal":"167.80","grand_total":"189.62","paid_amount":"189.62","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89397","customer_id":"89397","source_of_creation":"PMS","reservation_created_date":"2019-07-25 22:53:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"76.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":"3013897","reservation_id":"82309","confirmation_number":"PB12384117372","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.85,76.85","nightly_discount":"0.00,0.00","subtotal":"153.70","grand_total":"173.68","paid_amount":"173.68","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":"90003","customer_id":"90003","source_of_creation":"PMS","reservation_created_date":"2019-08-09 15:11:45","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":"76.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2996506","reservation_id":"79300","confirmation_number":"PB12220751715","room_confirmation_number":"PB12355711020","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"40.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"87944","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-07-08 17:35:50","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87944","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":"3002959","reservation_id":"81423","confirmation_number":"BV12250526782","room_confirmation_number":"BV12494953852","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"89391","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-07-25 19:50:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89391","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3004340","reservation_id":"81411","confirmation_number":"PB12288788975","room_confirmation_number":"PB12391703821","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"89379","product_attribute_values":"extra_person# ","reservation_created_date":"2019-07-28 20:56:26","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89379","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3005616","reservation_id":"81841","confirmation_number":"PB12293589697","room_confirmation_number":"PB12336427857","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"89682","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-08-01 19:42:11","reservation_modified_date_time":"2019-08-01 19:42:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89682","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":"3008027","reservation_id":"82196","confirmation_number":"BP12240916194","room_confirmation_number":"BP12577320649","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"50113","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-08-07 19:46:02","reservation_modified_date_time":"2019-08-07 19:46:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50113","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008490","reservation_id":"69614","confirmation_number":"BV12243547821","room_confirmation_number":"BV12440003514","room_stay_from":"2019-08-08","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"81963","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-08-08 20:30:32","reservation_modified_date_time":"2019-08-08 20:30:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81963","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008574","reservation_id":"79394","confirmation_number":"BP12249637621","room_confirmation_number":"BP12524781693","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"88006","product_attribute_values":"extra_person# ","reservation_created_date":"2019-08-09 00:19:24","reservation_modified_date_time":"2019-08-09 00:19:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88006","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009068","reservation_id":"82385","confirmation_number":"PB12280693563","room_confirmation_number":"PB12319224589","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"90043","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-08-10 03:00:22","reservation_modified_date_time":"2019-08-10 03:00:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90043","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":"3009575","reservation_id":"79286","confirmation_number":"PB12212882804","room_confirmation_number":"PB12389725674","room_stay_from":"2019-08-07","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"40,40,40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"240.00","grand_total":"271.20","paid_amount":"271.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"87934","product_attribute_values":"extra_person# ","reservation_created_date":"2019-08-11 18:50:19","reservation_modified_date_time":"2019-08-11 18:50:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87934","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"160.00","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":"3009582","reservation_id":"81751","confirmation_number":"PB12229712515","room_confirmation_number":"PB12339098834","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"89617","product_attribute_values":"extra_person# ","reservation_created_date":"2019-08-11 19:11:08","reservation_modified_date_time":"2019-08-11 19:11:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89617","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":"3009730","reservation_id":"80777","confirmation_number":"BP12263125816","room_confirmation_number":"BP12515026195","room_stay_from":"2019-08-11","room_stay_to":"2019-08-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,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":"88959","product_attribute_values":"extra_person# ","reservation_created_date":"2019-08-11 23:17:19","reservation_modified_date_time":"2019-08-11 23:17:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88959","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2920756","reservation_id":"67457","confirmation_number":"PB12247933860","room_confirmation_number":"PB12319499413","room_stay_from":"2019-08-05","room_stay_to":"2019-08-07","room_stay_status":"Canceled","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-21 07:33:13","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80668","parentCustTravId":"80668","customer_traveller_id":"80668","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-08-11 18:09:20","canceled_nights_data":"","product_attribute_values":"extra_person# .00","deltaChange":-60,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2962780","reservation_id":"74034","confirmation_number":"PB12268689583","room_confirmation_number":"PB12348835370","room_stay_from":"2019-08-08","room_stay_to":"2019-08-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":"84616","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-04 18:07:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84616","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":"2979087","reservation_id":"53432","confirmation_number":"PB12347834991","room_confirmation_number":"PB12374646801","room_stay_from":"2019-08-06","room_stay_to":"2019-08-22","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.00,0.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23537","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-08-11 17:56:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23537","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2984193","reservation_id":"77933","confirmation_number":"BP12251920288","room_confirmation_number":"BP12593583781","room_stay_from":"2019-08-11","room_stay_to":"2019-08-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"87132","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-04 02:44:56","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87132","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":"2986572","reservation_id":"77828","confirmation_number":"BV12265679985","room_confirmation_number":"BV12461603372","room_stay_from":"2019-08-10","room_stay_to":"2019-08-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"87052","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-02 17:09:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87052","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":"2987116","reservation_id":"78489","confirmation_number":"PB12253520977","room_confirmation_number":"PB12389442012","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"1781","service_quantity":"1","customer_traveller_id":"87541","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-11 21:06:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87541","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":"2989305","reservation_id":"54228","confirmation_number":"PBR12282947756","room_confirmation_number":"PB12320020546","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"73295","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73295","canceled_nights_data":"","currentDayPrice":"12.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":"2989309","reservation_id":"78883","confirmation_number":"PB12249264700","room_confirmation_number":"PB12347855915","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","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":"73295","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-18 01:32:50","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73295","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":"2990399","reservation_id":"79337","confirmation_number":"PB12246053798","room_confirmation_number":"PB12388297548","room_stay_from":"2019-08-10","room_stay_to":"2019-08-15","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":"87969","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-21 16:52:04","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73295","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":"2991510","reservation_id":"79517","confirmation_number":"PB12270064922","room_confirmation_number":"PB12360497460","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","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":"88081","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-24 15:25:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88081","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":"2991512","reservation_id":"79513","confirmation_number":"PB12261262738","room_confirmation_number":"PB12315933154","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","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":"88077","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-24 14:07:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72925","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":"2993061","reservation_id":"79794","confirmation_number":"PB12214775527","room_confirmation_number":"PB12380957904","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"88291","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-28 18:07:56","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88291","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":"2996505","reservation_id":"79300","confirmation_number":"PB12283384258","room_confirmation_number":"PB12355711020","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","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":"87944","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-20 21:05:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87944","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":"2997313","reservation_id":"79643","confirmation_number":"PB12295678341","room_confirmation_number":"PB12382874275","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"1781","service_quantity":"1","customer_traveller_id":"88184","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-26 18:44: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":"88184","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":"3002958","reservation_id":"81423","confirmation_number":"BV12271472695","room_confirmation_number":"BV12494953852","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"89391","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-25 19:50:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89391","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":"3003834","reservation_id":"81552","confirmation_number":"PB12234926632","room_confirmation_number":"PB12370869808","room_stay_from":"2019-08-10","room_stay_to":"2019-08-16","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":"89450","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-27 17:09:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89450","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":"3004341","reservation_id":"81411","confirmation_number":"PB12280021228","room_confirmation_number":"PB12391703821","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"89379","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-25 16:44:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89379","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":"3004351","reservation_id":"79794","confirmation_number":"PB12223354221","room_confirmation_number":"PB12378389803","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"88291","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-28 18:07:57","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88291","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":"3004387","reservation_id":"81632","confirmation_number":"BP12255101365","room_confirmation_number":"BP12527736744","room_stay_from":"2019-08-08","room_stay_to":"2019-08-13","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":"89505","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-28 22:39:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72474","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":"3005298","reservation_id":"78030","confirmation_number":"BV12250998352","room_confirmation_number":"BV12485808845","room_stay_from":"2019-08-10","room_stay_to":"2019-08-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"87223","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-05 16:45:41","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87223","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":"3005617","reservation_id":"81841","confirmation_number":"PB12296382351","room_confirmation_number":"PB12336427857","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","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":"89682","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-01 19:42:11","reservation_modified_date_time":"2019-08-01 19:42:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89682","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":"3006439","reservation_id":"81952","confirmation_number":"BV12210040751","room_confirmation_number":"BV12416452213","room_stay_from":"2019-08-09","room_stay_to":"2019-08-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":"1781","service_quantity":"1","customer_traveller_id":"89750","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-03 17:55:11","reservation_modified_date_time":"2019-08-03 17:55:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89750","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":"3007862","reservation_id":"80896","confirmation_number":"BP12268068460","room_confirmation_number":"BP12558542356","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","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":"89053","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-17 23:05:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89053","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":"3007898","reservation_id":"53430","confirmation_number":"PB12369542379","room_confirmation_number":"PB12356181331","room_stay_from":"2019-08-07","room_stay_to":"2019-08-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","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":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"39828","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-08-11 17:48:14","reservation_modified_date_time":"2019-08-07 16:07:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"39828","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":"3008028","reservation_id":"82196","confirmation_number":"BP12221168488","room_confirmation_number":"BP12577320649","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","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":"50113","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-07 19:46:02","reservation_modified_date_time":"2019-08-07 19:46:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50113","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":"3008156","reservation_id":"82180","confirmation_number":"BV12254881315","room_confirmation_number":"BV12425343611","room_stay_from":"2019-08-10","room_stay_to":"2019-08-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"89875","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-07 14:36:49","reservation_modified_date_time":"2019-08-07 14:36:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89875","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":"3008311","reservation_id":"75962","confirmation_number":"PB12277105280","room_confirmation_number":"PB12347682774","room_stay_from":"2019-08-08","room_stay_to":"2019-08-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"28101","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-05-07 21:55:04","reservation_modified_date_time":"2019-08-08 14:43:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28101","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":"3008491","reservation_id":"69614","confirmation_number":"BV12299483730","room_confirmation_number":"BV12440003514","room_stay_from":"2019-08-08","room_stay_to":"2019-08-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":"81964","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-02-16 21:04:23","reservation_modified_date_time":"2019-08-08 20:30:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81963","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":"3008554","reservation_id":"81651","confirmation_number":"BV12248202915","room_confirmation_number":"BV12464034907","room_stay_from":"2019-08-04","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"35292","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-29 14:14:59","reservation_modified_date_time":"2019-08-08 22:44:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"35292","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":"3008575","reservation_id":"79394","confirmation_number":"BP12288144832","room_confirmation_number":"BP12524781693","room_stay_from":"2019-08-07","room_stay_to":"2019-08-12","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":"88006","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-22 17:55:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88006","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":"3008775","reservation_id":"82316","confirmation_number":"PB12216146692","room_confirmation_number":"PB12341200209","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","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":"90009","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-09 16:03:13","reservation_modified_date_time":"2019-08-09 16:03:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73295","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":"3009554","reservation_id":"82406","confirmation_number":"BV12276296403","room_confirmation_number":"BV12419288376","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","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":"56194","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-10 16:39:49","reservation_modified_date_time":"2019-08-11 16:44:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56194","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":"3009578","reservation_id":"79286","confirmation_number":"PB12288310511","room_confirmation_number":"PB12389725674","room_stay_from":"2019-08-07","room_stay_to":"2019-08-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":"87934","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-20 18:15:10","reservation_modified_date_time":"2019-08-11 18:54:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87934","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":"3009580","reservation_id":"82479","confirmation_number":"BV12251147290","room_confirmation_number":"BV12415480155","room_stay_from":"2019-08-11","room_stay_to":"2019-08-12","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":"90090","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-11 19:07:04","reservation_modified_date_time":"2019-08-11 19:07:04","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90090","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3009612","reservation_id":"81751","confirmation_number":"PB12218152788","room_confirmation_number":"PB12339098834","room_stay_from":"2019-08-11","room_stay_to":"2019-08-15","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":"89617","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-31 14:48:08","reservation_modified_date_time":"2019-08-11 20:41:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89617","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":"3009624","reservation_id":"82385","confirmation_number":"PB12211559380","room_confirmation_number":"PB12319224589","room_stay_from":"2019-08-11","room_stay_to":"2019-08-13","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":"90043","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-10 03:00:22","reservation_modified_date_time":"2019-08-11 21:15:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90043","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":"3009731","reservation_id":"80777","confirmation_number":"BP12299977414","room_confirmation_number":"BP12515026195","room_stay_from":"2019-08-11","room_stay_to":"2019-08-17","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":"88959","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-15 18:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88959","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":"3009735","reservation_id":"82496","confirmation_number":"BV12273448469","room_confirmation_number":"BV12463573036","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","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":"90107","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-11 23:38:12","reservation_modified_date_time":"2019-08-11 23:38:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90107","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":"3009751","reservation_id":"82503","confirmation_number":"BV12233293797","room_confirmation_number":"BV12447741952","room_stay_from":"2019-08-11","room_stay_to":"2019-08-12","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":"90114","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-12 01:14:56","reservation_modified_date_time":"2019-08-12 01:14:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90114","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":"3010702","reservation_id":"53441","confirmation_number":"PB12399452323","room_confirmation_number":"PB12320508866","room_stay_from":"2019-08-08","room_stay_to":"2019-08-15","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":"23536","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-08-11 19:03:12","reservation_modified_date_time":"2019-08-15 15:15:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23536","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":"3013823","reservation_id":"82475","confirmation_number":"PB12298678386","room_confirmation_number":"PB12318344215","room_stay_from":"2019-08-11","room_stay_to":"2019-08-16","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"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":"90086","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-11 16:29:20","reservation_modified_date_time":"2019-08-25 20:53:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90086","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":"3013840","reservation_id":"81438","confirmation_number":"PB12235054218","room_confirmation_number":"PB12361966034","room_stay_from":"2019-08-10","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89397","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-25 22:53:33","reservation_modified_date_time":"2019-08-25 21:00:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89397","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":"2920754","reservation_id":"67456","confirmation_number":"BP12272042708","room_confirmation_number":"BP12593388772","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","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":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-21 07:29:12","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80667","parentCustTravId":"80667","customer_traveller_id":"80667","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#","currentDayPrice":20,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2936598","reservation_id":"69614","confirmation_number":"BV12269680554","room_confirmation_number":"BV12440003514","room_stay_from":"2019-08-08","room_stay_to":"2019-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 21:53:33","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81963","parentCustTravId":"81963","customer_traveller_id":"81964","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":"2983706","reservation_id":"77828","confirmation_number":"BV12211984930","room_confirmation_number":"BV12461603372","room_stay_from":"2019-08-10","room_stay_to":"2019-08-17","room_stay_status":"Active","nightly_price":"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","subtotal":"175.00","grand_total":"197.75","paid_amount":"197.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-02 17:09:18","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87052","parentCustTravId":"87052","customer_traveller_id":"87052","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":"2984192","reservation_id":"77933","confirmation_number":"BP12271466401","room_confirmation_number":"BP12593583781","room_stay_from":"2019-08-11","room_stay_to":"2019-08-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"367.25","paid_amount":"367.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-04 02:44:56","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87132","parentCustTravId":"87132","customer_traveller_id":"87132","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":"3008026","reservation_id":"82196","confirmation_number":"BP12234689104","room_confirmation_number":"BP12577320649","room_stay_from":"2019-08-11","room_stay_to":"2019-08-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-07 19:46:02","reservation_modified_date_time":"2019-08-07 19:46:02","customer_id":"50113","parentCustTravId":"50113","customer_traveller_id":"50113","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":"3009493","reservation_id":"81552","confirmation_number":"PB12262216698","room_confirmation_number":"PB12370869808","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":"2019-08-11 13:14:10","reservation_modified_date_time":"2019-08-11 13:14:10","customer_id":"89450","parentCustTravId":"89450","customer_traveller_id":"89450","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":"3009494","reservation_id":"81552","confirmation_number":"PB12244644466","room_confirmation_number":"PB12370869808","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":"2019-08-11 13:14:10","reservation_modified_date_time":"2019-08-11 13:14:10","customer_id":"89450","parentCustTravId":"89450","customer_traveller_id":"89450","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":"3009519","reservation_id":"82471","confirmation_number":"PB12263718885","room_confirmation_number":"PB12380508806","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 15:46:35","reservation_modified_date_time":"2019-08-11 15:46:35","customer_id":"90081","parentCustTravId":"90081","customer_traveller_id":"90081","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009544","reservation_id":"82475","confirmation_number":"PB12288882351","room_confirmation_number":"PB12318344215","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1217","service_quantity":"5","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 16:29:46","reservation_modified_date_time":"2019-08-11 16:29:46","customer_id":"90086","parentCustTravId":"90086","customer_traveller_id":"90086","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009620","reservation_id":"81438","confirmation_number":"PB12279778899","room_confirmation_number":"PB12361966034","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1156","service_quantity":"2","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 02:34:29","reservation_modified_date_time":"2019-08-11 21:10:31","customer_id":"89397","parentCustTravId":"89397","customer_traveller_id":"89397","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","changedComment":"price, discount or quantity changed","deltaChange":"25.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009636","reservation_id":"82488","confirmation_number":"PB12258371685","room_confirmation_number":"PB12345179193","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 21:33:53","reservation_modified_date_time":"2019-08-11 21:33:53","customer_id":"90098","parentCustTravId":"90098","customer_traveller_id":"90098","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009722","reservation_id":"82494","confirmation_number":"PB12216352003","room_confirmation_number":"PB12329121780","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-11 22:53:46","reservation_modified_date_time":"2019-08-11 22:53:46","customer_id":"90105","parentCustTravId":"90105","customer_traveller_id":"90105","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3009746","reservation_id":"82501","confirmation_number":"PB12297944909","room_confirmation_number":"PB12320380057","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-12 00:47:24","reservation_modified_date_time":"2019-08-12 00:47:24","customer_id":"90112","parentCustTravId":"90112","customer_traveller_id":"90112","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3005185","reservation_id":"81765","confirmation_number":"PB12249662462","room_confirmation_number":"PB12323643994","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-31 18:46:41","reservation_modified_date_time":"2019-07-31 18:46:41","customer_id":"89630","parentCustTravId":"89630","customer_traveller_id":"89630","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-08-11 19:30:07","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-40,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}