{"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":11,"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":"2987195","reservation_id":"78511","confirmation_number":"PB12316899458","room_stay_from":"2019-09-19","room_stay_to":"2019-09-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.20,93.35,93.35,84.20","nightly_discount":"0,0,0,0","subtotal":"355.10","grand_total":"401.27","paid_amount":"401.27","room_type_id":"290","product_id":"1113","siteminder_id":"BDC-3012117132","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":"87561","customer_id":"87561","source_of_creation":"Booking.com","reservation_created_date":"2019-06-12 01:57:08","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"65.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2991877","reservation_id":"79590","confirmation_number":"PB12393011148","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"90.52,90.52,100.62","nightly_discount":"0,0,0","subtotal":"281.66","grand_total":"318.28","paid_amount":"318.28","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1285885772","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88136","customer_id":"88136","source_of_creation":"Expedia","reservation_created_date":"2019-06-25 19:40:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.52","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":"2993922","reservation_id":"79982","confirmation_number":"PB12341637129","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"88.83,88.83,100.27","nightly_discount":"0,0,0","subtotal":"277.93","grand_total":"314.07","paid_amount":"314.07","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1289897690","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":"88422","customer_id":"88422","source_of_creation":"Expedia","reservation_created_date":"2019-07-01 11:39:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001538","reservation_id":"81170","confirmation_number":"PB12315502603","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.06,153.38,153.38","nightly_discount":"0,0,0","subtotal":"447.82","grand_total":"506.04","paid_amount":"506.04","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1304965952","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":"89208","customer_id":"89208","source_of_creation":"Expedia","reservation_created_date":"2019-07-21 19:04:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"141.06","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":"3007726","reservation_id":"82144","confirmation_number":"PB12363769051","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"122.43,133.87,133.87","nightly_discount":"0,0,0","subtotal":"390.17","grand_total":"440.89","paid_amount":"440.89","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1316395572","collect_which":"hotel_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":"89891","customer_id":"89891","source_of_creation":"Expedia","reservation_created_date":"2019-08-06 19:22:12","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":"122.43","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":"3016427","reservation_id":"83633","confirmation_number":"PB12343852288","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"131.12,98.76,98.76,98.76,98.76,98.76","nightly_discount":"0,0,0,0,0,0","subtotal":"624.92","grand_total":"706.16","paid_amount":"706.16","room_type_id":"289","product_id":"1109","siteminder_id":"EXP-1336149780","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":"91028","customer_id":"91028","source_of_creation":"Expedia","reservation_created_date":"2019-09-05 01:41:16","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":"98.76","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":"3018490","reservation_id":"83973","confirmation_number":"PB12338299789","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.42,147.20,183.99","nightly_discount":"0,0,0","subtotal":"455.61","grand_total":"514.84","paid_amount":"514.84","room_type_id":"287","product_id":"1087","siteminder_id":"EXP-1341011332","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":"91530","customer_id":"91530","source_of_creation":"Expedia","reservation_created_date":"2019-09-12 13:06:10","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.42","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020120","reservation_id":"84218","confirmation_number":"PB12339418230","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.44,130.44","nightly_discount":"0,0","subtotal":"260.88","grand_total":"294.79","paid_amount":"294.79","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1343676729","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":"91704","customer_id":"91704","source_of_creation":"Expedia","reservation_created_date":"2019-09-16 20:02:10","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":"130.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020201","reservation_id":"84238","confirmation_number":"PB12364493384","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"90.47","nightly_discount":"0","subtotal":"90.47","grand_total":"102.23","paid_amount":"102.23","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1343949327","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":"91724","customer_id":"91724","source_of_creation":"Expedia","reservation_created_date":"2019-09-17 04:37:09","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":"90.47","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2989800","reservation_id":"78975","confirmation_number":"PB12338285712","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.99,62.72,62.72","nightly_discount":"0,0,0","subtotal":"182.43","grand_total":"206.15","paid_amount":"206.15","room_type_id":"292","product_id":"1120","siteminder_id":"HTN-88632605-H7KMVX","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":"87896","customer_id":"87896","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-19 18:39:05","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":"56.99","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3008765","reservation_id":"82313","confirmation_number":"PB12386184595","room_stay_from":"2019-09-18","room_stay_to":"2019-09-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.07,89.07,96.85,96.85,89.07","nightly_discount":"0,0,0,0,0","subtotal":"460.91","grand_total":"520.82","paid_amount":"520.82","room_type_id":"286","product_id":"1086","siteminder_id":"GAM-R1609316755","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":"90006","customer_id":"90006","source_of_creation":"Getaroom.com","reservation_created_date":"2019-08-09 15:53:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.07","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3020747","reservation_id":"84309","confirmation_number":"PB12346549641","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"68.32,68.32","nightly_discount":"0.00,0.00","subtotal":"136.64","grand_total":"154.40","paid_amount":"154.40","room_type_id":"289","product_id":"1095","siteminder_id":"AGO-281107794","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91784","customer_id":"91784","source_of_creation":"Agoda","reservation_created_date":"2019-09-18 15:03:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020971","reservation_id":"84347","confirmation_number":"PB12383777761","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"68.32","nightly_discount":"0","subtotal":"68.32","grand_total":"77.20","paid_amount":"77.20","room_type_id":"289","product_id":"1107","siteminder_id":"AGO-281261070","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91816","customer_id":"91816","source_of_creation":"Agoda","reservation_created_date":"2019-09-19 13:33:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2982575","reservation_id":"77612","confirmation_number":"PB12320999864","room_stay_from":"2019-09-16","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"536.00","grand_total":"605.68","paid_amount":"605.68","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86914","customer_id":"86914","source_of_creation":"FE","reservation_created_date":"2019-05-30 15:01:26","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020301","reservation_id":"80513","confirmation_number":"PB12332832253","room_stay_from":"2019-09-17","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00","subtotal":"312.00","grand_total":"352.56","paid_amount":"352.56","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":"88789","customer_id":"88789","source_of_creation":"FE","reservation_created_date":"2019-07-10 23:37:23","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2871207","reservation_id":"56970","confirmation_number":"PB12385943697","room_stay_from":"2019-09-16","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.00,109.00,109.00,109.00,109.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"545.00","grand_total":"615.85","paid_amount":"615.85","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"62692","customer_id":"62692","source_of_creation":"PMS","reservation_created_date":"2018-09-23 14:12:14","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":"109.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985009","reservation_id":"78127","confirmation_number":"PB12361931698","room_stay_from":"2019-09-17","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"428.00","grand_total":"483.64","paid_amount":"483.64","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87290","customer_id":"87290","source_of_creation":"PMS","reservation_created_date":"2019-06-06 18:30:51","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3019251","reservation_id":"79395","confirmation_number":"PB12386303594","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,38.00,0.00,0.00,0.00,0.00,0.00","subtotal":"794.99","grand_total":"855.40","paid_amount":"855.41","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88007","customer_id":"88007","source_of_creation":"PMS","reservation_created_date":"2019-06-22 18:06:59","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3019678","reservation_id":"79861","confirmation_number":"PB12322920894","room_stay_from":"2019-09-15","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.80,148.80,148.80,148.80,148.80,164.80,164.80","nightly_discount":"0.00,50.39,0.00,0.00,0.00,0.00,0.00","subtotal":"1073.60","grand_total":"1156.22","paid_amount":"1156.22","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":"70722","customer_id":"70722","source_of_creation":"PMS","reservation_created_date":"2019-06-29 14:29:37","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":"148.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3019916","reservation_id":"81671","confirmation_number":"PB12372254241","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,18.41","subtotal":"416.00","grand_total":"449.28","paid_amount":"449.28","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":"89546","customer_id":"89546","source_of_creation":"PMS","reservation_created_date":"2019-07-29 18:55:50","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":"104.00","currentDayDiscount":"18.41","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020465","reservation_id":"84268","confirmation_number":"PB12322648139","room_stay_from":"2019-09-19","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,118.00","nightly_discount":"0.00,0.00","subtotal":"217.00","grand_total":"245.21","paid_amount":"245.21","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91752","customer_id":"91752","source_of_creation":"PMS","reservation_created_date":"2019-09-17 23:41:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020625","reservation_id":"84310","confirmation_number":"PB12312554000","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.13,97.98,122.48","nightly_discount":"0.00,0.00,0.00","subtotal":"300.59","grand_total":"339.67","paid_amount":"339.67","room_type_id":"313","product_id":"1228","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":"91731","customer_id":"91731","source_of_creation":"PMS","reservation_created_date":"2019-09-18 15:08:25","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020740","reservation_id":"81292","confirmation_number":"PB12334530932","room_stay_from":"2019-09-09","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,112.00,112.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1088.00","grand_total":"1229.44","paid_amount":"1229.44","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":"89302","customer_id":"89302","source_of_creation":"PMS","reservation_created_date":"2019-07-23 20:36:04","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":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020926","reservation_id":"84353","confirmation_number":"PB12381669453","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","room_type_id":"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":"91822","customer_id":"91822","source_of_creation":"PMS","reservation_created_date":"2019-09-19 17:17:41","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020974","reservation_id":"84364","confirmation_number":"PB12335667024","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","room_type_id":"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":"70297","customer_id":"70297","source_of_creation":"PMS","reservation_created_date":"2019-09-19 18:38:38","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020986","reservation_id":"57204","confirmation_number":"PB12334544524","room_stay_from":"2019-09-19","room_stay_to":"2019-09-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.00,109.00,109.00,109.00,109.00,109.00,109.00,109.00,109.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,43.60,0.00","subtotal":"981.00","grand_total":"1059.26","paid_amount":"1059.26","room_type_id":"289","product_id":"1098","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":"31302","customer_id":"31302","source_of_creation":"PMS","reservation_created_date":"2018-09-27 19:18:17","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":"109.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021004","reservation_id":"84363","confirmation_number":"PB12320356960","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00","nightly_discount":"8.10,0.00","subtotal":"150.00","grand_total":"160.34","paid_amount":"160.34","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":"91830","customer_id":"91830","source_of_creation":"PMS","reservation_created_date":"2019-09-19 18:24:34","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":"150.00","currentDayDiscount":"8.10","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026117","reservation_id":"81326","confirmation_number":"PB12339758680","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"376.00","grand_total":"424.88","paid_amount":"424.88","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88261","customer_id":"88261","source_of_creation":"PMS","reservation_created_date":"2019-07-24 14:08:51","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028598","reservation_id":"84295","confirmation_number":"PB12328331395","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00","nightly_discount":"0.00","subtotal":"94.00","grand_total":"106.22","paid_amount":"106.22","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":"91773","customer_id":"91773","source_of_creation":"PMS","reservation_created_date":"2019-09-18 12:18:52","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":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028628","reservation_id":"84352","confirmation_number":"PB12313282734","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00","nightly_discount":"0.00","subtotal":"94.00","grand_total":"106.22","paid_amount":"106.22","room_type_id":"291","product_id":"1117","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":"89644","customer_id":"89644","source_of_creation":"PMS","reservation_created_date":"2019-09-19 17:13:57","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"2978817","reservation_id":"56427","confirmation_number":"PB12356920696","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.00,174.00,174.00","nightly_discount":"0.00,0.00,0.00","subtotal":"522.00","grand_total":"589.86","paid_amount":"196.62","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":"48755","customer_id":"48755","source_of_creation":"PMS","reservation_created_date":"2018-09-15 22:24:33","service_canceled_date_time":"2019-07-22 14:03:25","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"196.62","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2991878","reservation_id":"79590","confirmation_number":"PB12240828146","room_confirmation_number":"PB12393011148","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","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":"88136","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-25 19:40:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88136","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":"2993923","reservation_id":"79982","confirmation_number":"PB12212954938","room_confirmation_number":"PB12341637129","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","room_stay_status":"Active","nightly_price":"40,40,40","nightly_discount":"0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"88422","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-01 11:39: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":"88422","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007727","reservation_id":"82144","confirmation_number":"PB12212255120","room_confirmation_number":"PB12363769051","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"89891","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-06 19:22:12","reservation_modified_date_time":"2019-08-06 19:22:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89891","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016428","reservation_id":"83633","confirmation_number":"PB12274639171","room_confirmation_number":"PB12343852288","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","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":"91028","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-05 01:41:16","reservation_modified_date_time":"2019-09-05 01:41:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91028","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":"3020749","reservation_id":"84309","confirmation_number":"PB12215654332","room_confirmation_number":"PB12346549641","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","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":"91784","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-18 20:46:44","reservation_modified_date_time":"2019-09-18 20:46:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91784","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":"3020972","reservation_id":"84347","confirmation_number":"PB12252502442","room_confirmation_number":"PB12383777761","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"91816","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-19 18:34:17","reservation_modified_date_time":"2019-09-19 18:34:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91816","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898807","reservation_id":"56970","confirmation_number":"PBR12294953879","room_confirmation_number":"PB12385943697","room_stay_from":"2019-09-16","room_stay_to":"2019-09-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"62692","product_attribute_values":"resort_fee#&#flat_rate#&#12.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":"62692","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":"2982576","reservation_id":"77612","confirmation_number":"PB12211338515","room_confirmation_number":"PB12320999864","room_stay_from":"2019-09-16","room_stay_to":"2019-09-21","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":"86914","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-30 15:01:26","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86914","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":"2985010","reservation_id":"78127","confirmation_number":"PB12284034098","room_confirmation_number":"PB12361931698","room_stay_from":"2019-09-17","room_stay_to":"2019-09-21","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":"87290","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-06 18:30:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87290","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":"2987196","reservation_id":"78511","confirmation_number":"PB12212424566","room_confirmation_number":"PB12316899458","room_stay_from":"2019-09-19","room_stay_to":"2019-09-23","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":"87561","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-12 01:57: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":"87561","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":"2989801","reservation_id":"78975","confirmation_number":"PB12289431423","room_confirmation_number":"PB12338285712","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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":"87896","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-19 18:39:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87896","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":"2991879","reservation_id":"79590","confirmation_number":"PB12222852515","room_confirmation_number":"PB12393011148","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","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":"88136","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-25 19:40:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88136","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":"2993924","reservation_id":"79982","confirmation_number":"PB12238202952","room_confirmation_number":"PB12341637129","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","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":"88422","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-01 11:39: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":"88422","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":"3001539","reservation_id":"81170","confirmation_number":"PB12210937557","room_confirmation_number":"PB12315502603","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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":"89208","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-21 19:04:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89208","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":"3007728","reservation_id":"82144","confirmation_number":"PB12233746777","room_confirmation_number":"PB12363769051","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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":"89891","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-06 19:22:12","reservation_modified_date_time":"2019-08-06 19:22:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89891","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":"3008766","reservation_id":"82313","confirmation_number":"PB12262466410","room_confirmation_number":"PB12386184595","room_stay_from":"2019-09-18","room_stay_to":"2019-09-23","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":"90006","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-09 15:53:09","reservation_modified_date_time":"2019-08-09 15:53:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90006","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":"3016429","reservation_id":"83633","confirmation_number":"PB12262050890","room_confirmation_number":"PB12343852288","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","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":"91028","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-05 01:41:16","reservation_modified_date_time":"2019-09-05 01:41:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91028","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":"3018491","reservation_id":"83973","confirmation_number":"PB12222636862","room_confirmation_number":"PB12338299789","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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":"91530","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-12 13:06:10","reservation_modified_date_time":"2019-09-12 13:06:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91530","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":"3019252","reservation_id":"79395","confirmation_number":"PB12281772603","room_confirmation_number":"PB12386303594","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","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":"88007","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-22 18:06:59","reservation_modified_date_time":"2019-09-14 18:50:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88007","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":"3019679","reservation_id":"79861","confirmation_number":"PB12256121090","room_confirmation_number":"PB12322920894","room_stay_from":"2019-09-15","room_stay_to":"2019-09-22","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":"70722","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-29 14:29:37","reservation_modified_date_time":"2019-09-15 18:48:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70722","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":"3019917","reservation_id":"81671","confirmation_number":"PB12236863945","room_confirmation_number":"PB12372254241","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"89546","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-29 18:55:50","reservation_modified_date_time":"2019-09-16 15:31:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89546","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":"3020121","reservation_id":"84218","confirmation_number":"PB12219536770","room_confirmation_number":"PB12339418230","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91704","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-16 20:02:10","reservation_modified_date_time":"2019-09-16 20:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91704","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":"3020202","reservation_id":"84238","confirmation_number":"PB12248548345","room_confirmation_number":"PB12364493384","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"91724","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-17 04:37:09","reservation_modified_date_time":"2019-09-17 04:37:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91724","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":"3020302","reservation_id":"80513","confirmation_number":"PB12233458921","room_confirmation_number":"PB12332832253","room_stay_from":"2019-09-17","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"88789","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-10 23:37:23","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88789","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":"3020466","reservation_id":"84268","confirmation_number":"PB12266002323","room_confirmation_number":"PB12322648139","room_stay_from":"2019-09-19","room_stay_to":"2019-09-21","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"91752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-17 23:41:02","reservation_modified_date_time":"2019-09-18 01:32:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91752","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":"3020626","reservation_id":"84310","confirmation_number":"PB12211028989","room_confirmation_number":"PB12312554000","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91731","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 15:08:25","reservation_modified_date_time":"2019-09-18 15:08:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91731","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":"3020741","reservation_id":"81292","confirmation_number":"PB12244842838","room_confirmation_number":"PB12334530932","room_stay_from":"2019-09-09","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,12.00,12.00,12.00,12.00","subtotal":"132.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"89302","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 20:36:04","reservation_modified_date_time":"2019-09-18 20:03:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89302","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"12.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020750","reservation_id":"84309","confirmation_number":"PB12256778909","room_confirmation_number":"PB12346549641","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91784","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 15:03:11","reservation_modified_date_time":"2019-09-18 20:46:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91784","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":"3020927","reservation_id":"84353","confirmation_number":"PB12246354557","room_confirmation_number":"PB12381669453","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91822","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 17:17:41","reservation_modified_date_time":"2019-09-19 17:17:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91822","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":"3020973","reservation_id":"84347","confirmation_number":"PB12224778307","room_confirmation_number":"PB12383777761","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"91816","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-19 13:33:13","reservation_modified_date_time":"2019-09-19 13:33:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91816","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":"3020975","reservation_id":"84364","confirmation_number":"PB12282816041","room_confirmation_number":"PB12335667024","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"70297","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 18:38:38","reservation_modified_date_time":"2019-09-19 18:38:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70297","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":"3020987","reservation_id":"57204","confirmation_number":"PB12390168004","room_confirmation_number":"PB12334544524","room_stay_from":"2019-09-19","room_stay_to":"2019-09-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"31302","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-09-27 19:19:09","reservation_modified_date_time":"2019-09-19 19:14:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"31302","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":"3021005","reservation_id":"84363","confirmation_number":"PB12251916445","room_confirmation_number":"PB12320356960","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91830","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 18:24:34","reservation_modified_date_time":"2019-09-19 19:49:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91830","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":"3028599","reservation_id":"84295","confirmation_number":"PB12219168519","room_confirmation_number":"PB12328331395","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91773","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 12:18:52","reservation_modified_date_time":"2019-10-15 14:44:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91773","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":"3028629","reservation_id":"84352","confirmation_number":"PB12216017174","room_confirmation_number":"PB12313282734","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89644","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 17:13:57","reservation_modified_date_time":"2019-10-15 15:09:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89644","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":"3020924","reservation_id":"84352","confirmation_number":"PB12264346993","room_confirmation_number":"PB12313282734","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-09-19 17:13:57","reservation_modified_date_time":"2019-09-19 17:13:57","customer_id":"89644","parentCustTravId":"89644","customer_traveller_id":"89644","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":"3021091","reservation_id":"84352","confirmation_number":"PB12298347131","room_confirmation_number":"PB12313282734","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-20 01:13:07","reservation_modified_date_time":"2019-09-20 01:13:07","customer_id":"89644","parentCustTravId":"89644","customer_traveller_id":"89644","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3021001","reservation_id":"84371","confirmation_number":"PB12297419279","room_confirmation_number":"PB12388701272","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":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-19 19:29:08","reservation_modified_date_time":"2019-09-19 19:29:08","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3020656","reservation_id":"84317","confirmation_number":"BV12488856491","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.18,68.18","nightly_discount":"0,0","subtotal":"136.36","grand_total":"154.09","paid_amount":"154.09","room_type_id":"304","product_id":"1219","siteminder_id":"AGO-281124190","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":"91791","customer_id":"91791","source_of_creation":"Agoda","reservation_created_date":"2019-09-18 16:57:06","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":"68.18","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3014436","reservation_id":"83301","confirmation_number":"BV12490276735","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88","nightly_discount":"0.00","subtotal":"110.88","grand_total":"125.29","paid_amount":"125.29","room_type_id":"309","product_id":"1226","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":"43072","customer_id":"43072","source_of_creation":"FE","reservation_created_date":"2019-08-27 19:20:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014951","reservation_id":"81272","confirmation_number":"BV12422589775","room_stay_from":"2019-09-11","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.60,129.60,145.60,145.60,129.60,129.60,129.60,129.60,129.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1198.40","grand_total":"1354.19","paid_amount":"1354.19","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":"64584","customer_id":"64584","source_of_creation":"FE","reservation_created_date":"2019-07-23 14:55:02","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":"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"}]}],"fe_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3014437","reservation_id":"83301","confirmation_number":"BV12250837452","room_confirmation_number":"BV12490276735","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"43072","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-27 19:20:00","reservation_modified_date_time":"2019-08-27 19:20:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"43072","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":"3014952","reservation_id":"81272","confirmation_number":"BV12225151771","room_confirmation_number":"BV12422589775","room_stay_from":"2019-09-11","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 14:55:02","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","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":"3020657","reservation_id":"84317","confirmation_number":"BV12227818725","room_confirmation_number":"BV12488856491","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91791","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 16:57:06","reservation_modified_date_time":"2019-09-18 16:57:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91791","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":"3020961","reservation_id":"84361","confirmation_number":"BV12257439837","room_confirmation_number":"BV12471019410","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"28.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1212","service_quantity":"3","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-19 18:18:31","reservation_modified_date_time":"2019-09-19 18:18:31","customer_id":"91829","parentCustTravId":"91829","customer_traveller_id":"91829","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":"84.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":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3020984","reservation_id":"84367","confirmation_number":"BP12581858957","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"59.27","nightly_discount":"0","subtotal":"59.27","grand_total":"66.98","paid_amount":"66.98","room_type_id":"300","product_id":"1135","siteminder_id":"BDC-3587427675","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":"91832","customer_id":"91832","source_of_creation":"Booking.com","reservation_created_date":"2019-09-19 18:54:12","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"8.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"59.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3005064","reservation_id":"81739","confirmation_number":"BP12526457719","room_stay_from":"2019-09-19","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"65.01,81.61","nightly_discount":"0,0","subtotal":"146.62","grand_total":"165.68","paid_amount":"165.68","room_type_id":"295","product_id":"1129","siteminder_id":"EXP-1311940799","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":"89607","customer_id":"89607","source_of_creation":"Expedia","reservation_created_date":"2019-07-31 12:02:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.01","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020801","reservation_id":"84320","confirmation_number":"BP12575460058","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"58.35,58.35","nightly_discount":"0,0","subtotal":"116.70","grand_total":"131.87","paid_amount":"131.87","room_type_id":"296","product_id":"1130","siteminder_id":"EXP-1345026698","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":"91793","customer_id":"91793","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 17:37:11","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":"58.35","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3017964","reservation_id":"83861","confirmation_number":"BP12516374308","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,127.00,148.00","nightly_discount":"0.00,0.00,0.00","subtotal":"375.00","grand_total":"423.75","paid_amount":"423.75","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91369","customer_id":"91369","source_of_creation":"PMS","reservation_created_date":"2019-09-10 01:14:43","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","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":"3019887","reservation_id":"83945","confirmation_number":"BP12513731838","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,92.00,92.00,92.00,92.00,92.00","nightly_discount":"0.00,11.80,0.00,0.00,0.00,5.78,0.00","subtotal":"580.00","grand_total":"635.54","paid_amount":"635.54","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":"91507","customer_id":"91507","source_of_creation":"PMS","reservation_created_date":"2019-09-14 12:26:08","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":"92.00","currentDayDiscount":"5.78","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020514","reservation_id":"84175","confirmation_number":"BP12592277240","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"47.27,47.27,47.27,47.27","nightly_discount":"0.00,4.36,0.00,6.37,0.00","subtotal":"189.08","grand_total":"201.53","paid_amount":"201.53","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90858","customer_id":"90858","source_of_creation":"PMS","reservation_created_date":"2019-09-16 00:48:17","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"47.27","currentDayDiscount":"6.37","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020660","reservation_id":"83876","confirmation_number":"BP12585438690","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"71.00,71.00","nightly_discount":"0.00,0.00","subtotal":"142.00","grand_total":"160.46","paid_amount":"160.46","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91382","customer_id":"91382","source_of_creation":"PMS","reservation_created_date":"2019-09-10 16:52:56","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020896","reservation_id":"84189","confirmation_number":"BP12533228007","room_stay_from":"2019-09-16","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.00,64.00,64.00,64.00,64.00,64.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"384.00","grand_total":"433.92","paid_amount":"433.92","room_type_id":"294","product_id":"1127","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":"91477","customer_id":"91477","source_of_creation":"PMS","reservation_created_date":"2019-09-16 13:18:30","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","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":"64.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021081","reservation_id":"84393","confirmation_number":"BP12520574202","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.76","nightly_discount":"0.00","subtotal":"77.76","grand_total":"87.87","paid_amount":"87.87","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":"91846","customer_id":"91846","source_of_creation":"PMS","reservation_created_date":"2019-09-20 00:44:36","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":"77.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028482","reservation_id":"84374","confirmation_number":"BP12572688457","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.11","nightly_discount":"0.00","subtotal":"76.11","grand_total":"86.01","paid_amount":"86.01","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91838","customer_id":"91838","source_of_creation":"PMS","reservation_created_date":"2019-09-19 20:15:46","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"76.11","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3005065","reservation_id":"81739","confirmation_number":"BP12219887453","room_confirmation_number":"BP12526457719","room_stay_from":"2019-09-19","room_stay_to":"2019-09-21","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":"89607","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-31 12:02:11","reservation_modified_date_time":"2019-07-31 12:02:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89607","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":"3017965","reservation_id":"83861","confirmation_number":"BP12220591027","room_confirmation_number":"BP12516374308","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"91369","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-10 01:14:43","reservation_modified_date_time":"2019-09-10 01:16:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91369","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":"3019888","reservation_id":"83945","confirmation_number":"BP12255020610","room_confirmation_number":"BP12513731838","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"91507","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-14 12:26:08","reservation_modified_date_time":"2019-09-16 14:58:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91507","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":"3020515","reservation_id":"84175","confirmation_number":"BP12212181643","room_confirmation_number":"BP12592277240","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"90858","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-16 00:48:17","reservation_modified_date_time":"2019-09-18 13:00:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90858","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":"3020663","reservation_id":"83876","confirmation_number":"BP12236647937","room_confirmation_number":"BP12585438690","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","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":"91382","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-10 16:52:56","reservation_modified_date_time":"2019-09-18 17:02:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91382","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":"3020802","reservation_id":"84320","confirmation_number":"BP12226215813","room_confirmation_number":"BP12575460058","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91793","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 17:37:11","reservation_modified_date_time":"2019-09-18 17:37:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91793","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":"3020897","reservation_id":"84189","confirmation_number":"BP12238466017","room_confirmation_number":"BP12533228007","room_stay_from":"2019-09-16","room_stay_to":"2019-09-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"91477","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-16 13:18:30","reservation_modified_date_time":"2019-09-18 17:48:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91477","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":"3020985","reservation_id":"84367","confirmation_number":"BP12294357759","room_confirmation_number":"BP12581858957","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"91832","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-19 18:54:12","reservation_modified_date_time":"2019-09-19 18:54:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91832","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":"3021082","reservation_id":"84393","confirmation_number":"BP12255073075","room_confirmation_number":"BP12520574202","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91846","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-20 00:44:36","reservation_modified_date_time":"2019-09-20 00:44:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91846","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":"3028483","reservation_id":"84374","confirmation_number":"BP12240142779","room_confirmation_number":"BP12572688457","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91838","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 20:15:46","reservation_modified_date_time":"2019-10-14 23:23:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91838","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":"3017959","reservation_id":"83861","confirmation_number":"BP12247883045","room_confirmation_number":"BP12516374308","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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-09-10 01:15:02","reservation_modified_date_time":"2019-09-10 01:15:02","customer_id":"91369","parentCustTravId":"91369","customer_traveller_id":"91369","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":"3020991","reservation_id":"84368","confirmation_number":"BP12246780854","room_confirmation_number":"BP12586917022","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":"84.75","paid_amount":"84.75","product_id":"1146","service_quantity":"3","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-19 19:19:15","reservation_modified_date_time":"2019-09-19 19:19:15","customer_id":"91833","parentCustTravId":"91833","customer_traveller_id":"91833","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":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3021027","reservation_id":"84374","confirmation_number":"BP12247231772","room_confirmation_number":"BP12572688457","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-19 20:35:16","reservation_modified_date_time":"2019-09-19 20:35:16","customer_id":"91838","parentCustTravId":"91838","customer_traveller_id":"91838","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":"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-09-19","total_rooms_exist":66,"departureCount":19,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"0","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2987195","reservation_id":"78511","confirmation_number":"PB12316899458","room_stay_from":"2019-09-19","room_stay_to":"2019-09-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.20,93.35,93.35,84.20","nightly_discount":"0,0,0,0","subtotal":"355.10","grand_total":"401.27","paid_amount":"401.27","room_type_id":"290","product_id":"1113","siteminder_id":"BDC-3012117132","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":"87561","customer_id":"87561","source_of_creation":"Booking.com","reservation_created_date":"2019-06-12 01:57:08","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"65.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.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":"3020984","reservation_id":"84367","confirmation_number":"BP12581858957","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"59.27","nightly_discount":"0","subtotal":"59.27","grand_total":"66.98","paid_amount":"66.98","room_type_id":"300","product_id":"1135","siteminder_id":"BDC-3587427675","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":"91832","customer_id":"91832","source_of_creation":"Booking.com","reservation_created_date":"2019-09-19 18:54:12","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"8.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"59.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2991877","reservation_id":"79590","confirmation_number":"PB12393011148","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"90.52,90.52,100.62","nightly_discount":"0,0,0","subtotal":"281.66","grand_total":"318.28","paid_amount":"318.28","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1285885772","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88136","customer_id":"88136","source_of_creation":"Expedia","reservation_created_date":"2019-06-25 19:40:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.52","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":"2993922","reservation_id":"79982","confirmation_number":"PB12341637129","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"88.83,88.83,100.27","nightly_discount":"0,0,0","subtotal":"277.93","grand_total":"314.07","paid_amount":"314.07","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1289897690","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":"88422","customer_id":"88422","source_of_creation":"Expedia","reservation_created_date":"2019-07-01 11:39:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001538","reservation_id":"81170","confirmation_number":"PB12315502603","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.06,153.38,153.38","nightly_discount":"0,0,0","subtotal":"447.82","grand_total":"506.04","paid_amount":"506.04","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1304965952","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":"89208","customer_id":"89208","source_of_creation":"Expedia","reservation_created_date":"2019-07-21 19:04:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"141.06","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":"3005064","reservation_id":"81739","confirmation_number":"BP12526457719","room_stay_from":"2019-09-19","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"65.01,81.61","nightly_discount":"0,0","subtotal":"146.62","grand_total":"165.68","paid_amount":"165.68","room_type_id":"295","product_id":"1129","siteminder_id":"EXP-1311940799","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":"89607","customer_id":"89607","source_of_creation":"Expedia","reservation_created_date":"2019-07-31 12:02:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.01","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007726","reservation_id":"82144","confirmation_number":"PB12363769051","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"122.43,133.87,133.87","nightly_discount":"0,0,0","subtotal":"390.17","grand_total":"440.89","paid_amount":"440.89","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1316395572","collect_which":"hotel_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":"89891","customer_id":"89891","source_of_creation":"Expedia","reservation_created_date":"2019-08-06 19:22:12","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":"122.43","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":"3016427","reservation_id":"83633","confirmation_number":"PB12343852288","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"131.12,98.76,98.76,98.76,98.76,98.76","nightly_discount":"0,0,0,0,0,0","subtotal":"624.92","grand_total":"706.16","paid_amount":"706.16","room_type_id":"289","product_id":"1109","siteminder_id":"EXP-1336149780","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":"91028","customer_id":"91028","source_of_creation":"Expedia","reservation_created_date":"2019-09-05 01:41:16","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":"98.76","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":"3018490","reservation_id":"83973","confirmation_number":"PB12338299789","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.42,147.20,183.99","nightly_discount":"0,0,0","subtotal":"455.61","grand_total":"514.84","paid_amount":"514.84","room_type_id":"287","product_id":"1087","siteminder_id":"EXP-1341011332","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":"91530","customer_id":"91530","source_of_creation":"Expedia","reservation_created_date":"2019-09-12 13:06:10","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.42","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020120","reservation_id":"84218","confirmation_number":"PB12339418230","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.44,130.44","nightly_discount":"0,0","subtotal":"260.88","grand_total":"294.79","paid_amount":"294.79","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1343676729","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":"91704","customer_id":"91704","source_of_creation":"Expedia","reservation_created_date":"2019-09-16 20:02:10","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":"130.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020201","reservation_id":"84238","confirmation_number":"PB12364493384","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"90.47","nightly_discount":"0","subtotal":"90.47","grand_total":"102.23","paid_amount":"102.23","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1343949327","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":"91724","customer_id":"91724","source_of_creation":"Expedia","reservation_created_date":"2019-09-17 04:37:09","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":"90.47","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":"3020801","reservation_id":"84320","confirmation_number":"BP12575460058","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"58.35,58.35","nightly_discount":"0,0","subtotal":"116.70","grand_total":"131.87","paid_amount":"131.87","room_type_id":"296","product_id":"1130","siteminder_id":"EXP-1345026698","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":"91793","customer_id":"91793","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 17:37:11","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":"58.35","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2989800","reservation_id":"78975","confirmation_number":"PB12338285712","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.99,62.72,62.72","nightly_discount":"0,0,0","subtotal":"182.43","grand_total":"206.15","paid_amount":"206.15","room_type_id":"292","product_id":"1120","siteminder_id":"HTN-88632605-H7KMVX","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":"87896","customer_id":"87896","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-19 18:39:05","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":"56.99","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3008765","reservation_id":"82313","confirmation_number":"PB12386184595","room_stay_from":"2019-09-18","room_stay_to":"2019-09-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.07,89.07,96.85,96.85,89.07","nightly_discount":"0,0,0,0,0","subtotal":"460.91","grand_total":"520.82","paid_amount":"520.82","room_type_id":"286","product_id":"1086","siteminder_id":"GAM-R1609316755","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":"90006","customer_id":"90006","source_of_creation":"Getaroom.com","reservation_created_date":"2019-08-09 15:53:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.07","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3020656","reservation_id":"84317","confirmation_number":"BV12488856491","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.18,68.18","nightly_discount":"0,0","subtotal":"136.36","grand_total":"154.09","paid_amount":"154.09","room_type_id":"304","product_id":"1219","siteminder_id":"AGO-281124190","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":"91791","customer_id":"91791","source_of_creation":"Agoda","reservation_created_date":"2019-09-18 16:57:06","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":"68.18","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":"3020747","reservation_id":"84309","confirmation_number":"PB12346549641","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"68.32,68.32","nightly_discount":"0.00,0.00","subtotal":"136.64","grand_total":"154.40","paid_amount":"154.40","room_type_id":"289","product_id":"1095","siteminder_id":"AGO-281107794","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91784","customer_id":"91784","source_of_creation":"Agoda","reservation_created_date":"2019-09-18 15:03:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020971","reservation_id":"84347","confirmation_number":"PB12383777761","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"68.32","nightly_discount":"0","subtotal":"68.32","grand_total":"77.20","paid_amount":"77.20","room_type_id":"289","product_id":"1107","siteminder_id":"AGO-281261070","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91816","customer_id":"91816","source_of_creation":"Agoda","reservation_created_date":"2019-09-19 13:33:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2982575","reservation_id":"77612","confirmation_number":"PB12320999864","room_stay_from":"2019-09-16","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"536.00","grand_total":"605.68","paid_amount":"605.68","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86914","customer_id":"86914","source_of_creation":"FE","reservation_created_date":"2019-05-30 15:01:26","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014436","reservation_id":"83301","confirmation_number":"BV12490276735","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88","nightly_discount":"0.00","subtotal":"110.88","grand_total":"125.29","paid_amount":"125.29","room_type_id":"309","product_id":"1226","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":"43072","customer_id":"43072","source_of_creation":"FE","reservation_created_date":"2019-08-27 19:20:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014951","reservation_id":"81272","confirmation_number":"BV12422589775","room_stay_from":"2019-09-11","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.60,129.60,145.60,145.60,129.60,129.60,129.60,129.60,129.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1198.40","grand_total":"1354.19","paid_amount":"1354.19","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":"64584","customer_id":"64584","source_of_creation":"FE","reservation_created_date":"2019-07-23 14:55:02","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":"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":"3020301","reservation_id":"80513","confirmation_number":"PB12332832253","room_stay_from":"2019-09-17","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00","subtotal":"312.00","grand_total":"352.56","paid_amount":"352.56","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":"88789","customer_id":"88789","source_of_creation":"FE","reservation_created_date":"2019-07-10 23:37:23","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2871207","reservation_id":"56970","confirmation_number":"PB12385943697","room_stay_from":"2019-09-16","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.00,109.00,109.00,109.00,109.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"545.00","grand_total":"615.85","paid_amount":"615.85","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"62692","customer_id":"62692","source_of_creation":"PMS","reservation_created_date":"2018-09-23 14:12:14","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":"109.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985009","reservation_id":"78127","confirmation_number":"PB12361931698","room_stay_from":"2019-09-17","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"428.00","grand_total":"483.64","paid_amount":"483.64","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87290","customer_id":"87290","source_of_creation":"PMS","reservation_created_date":"2019-06-06 18:30:51","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017964","reservation_id":"83861","confirmation_number":"BP12516374308","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,127.00,148.00","nightly_discount":"0.00,0.00,0.00","subtotal":"375.00","grand_total":"423.75","paid_amount":"423.75","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91369","customer_id":"91369","source_of_creation":"PMS","reservation_created_date":"2019-09-10 01:14:43","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","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":"3019251","reservation_id":"79395","confirmation_number":"PB12386303594","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,38.00,0.00,0.00,0.00,0.00,0.00","subtotal":"794.99","grand_total":"855.40","paid_amount":"855.41","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88007","customer_id":"88007","source_of_creation":"PMS","reservation_created_date":"2019-06-22 18:06:59","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3019678","reservation_id":"79861","confirmation_number":"PB12322920894","room_stay_from":"2019-09-15","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.80,148.80,148.80,148.80,148.80,164.80,164.80","nightly_discount":"0.00,50.39,0.00,0.00,0.00,0.00,0.00","subtotal":"1073.60","grand_total":"1156.22","paid_amount":"1156.22","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":"70722","customer_id":"70722","source_of_creation":"PMS","reservation_created_date":"2019-06-29 14:29:37","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":"148.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3019887","reservation_id":"83945","confirmation_number":"BP12513731838","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,92.00,92.00,92.00,92.00,92.00","nightly_discount":"0.00,11.80,0.00,0.00,0.00,5.78,0.00","subtotal":"580.00","grand_total":"635.54","paid_amount":"635.54","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":"91507","customer_id":"91507","source_of_creation":"PMS","reservation_created_date":"2019-09-14 12:26:08","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":"92.00","currentDayDiscount":"5.78","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3019916","reservation_id":"81671","confirmation_number":"PB12372254241","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,18.41","subtotal":"416.00","grand_total":"449.28","paid_amount":"449.28","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":"89546","customer_id":"89546","source_of_creation":"PMS","reservation_created_date":"2019-07-29 18:55:50","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":"104.00","currentDayDiscount":"18.41","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020465","reservation_id":"84268","confirmation_number":"PB12322648139","room_stay_from":"2019-09-19","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,118.00","nightly_discount":"0.00,0.00","subtotal":"217.00","grand_total":"245.21","paid_amount":"245.21","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91752","customer_id":"91752","source_of_creation":"PMS","reservation_created_date":"2019-09-17 23:41:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020514","reservation_id":"84175","confirmation_number":"BP12592277240","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"47.27,47.27,47.27,47.27","nightly_discount":"0.00,4.36,0.00,6.37,0.00","subtotal":"189.08","grand_total":"201.53","paid_amount":"201.53","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90858","customer_id":"90858","source_of_creation":"PMS","reservation_created_date":"2019-09-16 00:48:17","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"47.27","currentDayDiscount":"6.37","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020625","reservation_id":"84310","confirmation_number":"PB12312554000","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.13,97.98,122.48","nightly_discount":"0.00,0.00,0.00","subtotal":"300.59","grand_total":"339.67","paid_amount":"339.67","room_type_id":"313","product_id":"1228","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":"91731","customer_id":"91731","source_of_creation":"PMS","reservation_created_date":"2019-09-18 15:08:25","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020660","reservation_id":"83876","confirmation_number":"BP12585438690","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"71.00,71.00","nightly_discount":"0.00,0.00","subtotal":"142.00","grand_total":"160.46","paid_amount":"160.46","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91382","customer_id":"91382","source_of_creation":"PMS","reservation_created_date":"2019-09-10 16:52:56","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020740","reservation_id":"81292","confirmation_number":"PB12334530932","room_stay_from":"2019-09-09","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,112.00,112.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1088.00","grand_total":"1229.44","paid_amount":"1229.44","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":"89302","customer_id":"89302","source_of_creation":"PMS","reservation_created_date":"2019-07-23 20:36:04","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":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020896","reservation_id":"84189","confirmation_number":"BP12533228007","room_stay_from":"2019-09-16","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.00,64.00,64.00,64.00,64.00,64.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"384.00","grand_total":"433.92","paid_amount":"433.92","room_type_id":"294","product_id":"1127","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":"91477","customer_id":"91477","source_of_creation":"PMS","reservation_created_date":"2019-09-16 13:18:30","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","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":"64.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020926","reservation_id":"84353","confirmation_number":"PB12381669453","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","room_type_id":"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":"91822","customer_id":"91822","source_of_creation":"PMS","reservation_created_date":"2019-09-19 17:17:41","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020974","reservation_id":"84364","confirmation_number":"PB12335667024","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","room_type_id":"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":"70297","customer_id":"70297","source_of_creation":"PMS","reservation_created_date":"2019-09-19 18:38:38","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020986","reservation_id":"57204","confirmation_number":"PB12334544524","room_stay_from":"2019-09-19","room_stay_to":"2019-09-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.00,109.00,109.00,109.00,109.00,109.00,109.00,109.00,109.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,43.60,0.00","subtotal":"981.00","grand_total":"1059.26","paid_amount":"1059.26","room_type_id":"289","product_id":"1098","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":"31302","customer_id":"31302","source_of_creation":"PMS","reservation_created_date":"2018-09-27 19:18:17","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":"109.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021004","reservation_id":"84363","confirmation_number":"PB12320356960","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00","nightly_discount":"8.10,0.00","subtotal":"150.00","grand_total":"160.34","paid_amount":"160.34","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":"91830","customer_id":"91830","source_of_creation":"PMS","reservation_created_date":"2019-09-19 18:24:34","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":"150.00","currentDayDiscount":"8.10","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021081","reservation_id":"84393","confirmation_number":"BP12520574202","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.76","nightly_discount":"0.00","subtotal":"77.76","grand_total":"87.87","paid_amount":"87.87","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":"91846","customer_id":"91846","source_of_creation":"PMS","reservation_created_date":"2019-09-20 00:44:36","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":"77.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026117","reservation_id":"81326","confirmation_number":"PB12339758680","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"376.00","grand_total":"424.88","paid_amount":"424.88","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88261","customer_id":"88261","source_of_creation":"PMS","reservation_created_date":"2019-07-24 14:08:51","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028482","reservation_id":"84374","confirmation_number":"BP12572688457","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.11","nightly_discount":"0.00","subtotal":"76.11","grand_total":"86.01","paid_amount":"86.01","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91838","customer_id":"91838","source_of_creation":"PMS","reservation_created_date":"2019-09-19 20:15:46","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"76.11","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028598","reservation_id":"84295","confirmation_number":"PB12328331395","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00","nightly_discount":"0.00","subtotal":"94.00","grand_total":"106.22","paid_amount":"106.22","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":"91773","customer_id":"91773","source_of_creation":"PMS","reservation_created_date":"2019-09-18 12:18:52","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":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028628","reservation_id":"84352","confirmation_number":"PB12313282734","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00","nightly_discount":"0.00","subtotal":"94.00","grand_total":"106.22","paid_amount":"106.22","room_type_id":"291","product_id":"1117","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":"89644","customer_id":"89644","source_of_creation":"PMS","reservation_created_date":"2019-09-19 17:13:57","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"2978817","reservation_id":"56427","confirmation_number":"PB12356920696","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.00,174.00,174.00","nightly_discount":"0.00,0.00,0.00","subtotal":"522.00","grand_total":"589.86","paid_amount":"196.62","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":"48755","customer_id":"48755","source_of_creation":"PMS","reservation_created_date":"2018-09-15 22:24:33","service_canceled_date_time":"2019-07-22 14:03:25","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"196.62","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2991878","reservation_id":"79590","confirmation_number":"PB12240828146","room_confirmation_number":"PB12393011148","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","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":"88136","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-25 19:40:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88136","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":"2993923","reservation_id":"79982","confirmation_number":"PB12212954938","room_confirmation_number":"PB12341637129","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","room_stay_status":"Active","nightly_price":"40,40,40","nightly_discount":"0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"88422","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-01 11:39: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":"88422","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007727","reservation_id":"82144","confirmation_number":"PB12212255120","room_confirmation_number":"PB12363769051","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"89891","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-06 19:22:12","reservation_modified_date_time":"2019-08-06 19:22:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89891","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016428","reservation_id":"83633","confirmation_number":"PB12274639171","room_confirmation_number":"PB12343852288","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","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":"91028","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-05 01:41:16","reservation_modified_date_time":"2019-09-05 01:41:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91028","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":"3020749","reservation_id":"84309","confirmation_number":"PB12215654332","room_confirmation_number":"PB12346549641","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","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":"91784","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-18 20:46:44","reservation_modified_date_time":"2019-09-18 20:46:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91784","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":"3020972","reservation_id":"84347","confirmation_number":"PB12252502442","room_confirmation_number":"PB12383777761","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"91816","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-19 18:34:17","reservation_modified_date_time":"2019-09-19 18:34:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91816","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898807","reservation_id":"56970","confirmation_number":"PBR12294953879","room_confirmation_number":"PB12385943697","room_stay_from":"2019-09-16","room_stay_to":"2019-09-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"62692","product_attribute_values":"resort_fee#&#flat_rate#&#12.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":"62692","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":"2982576","reservation_id":"77612","confirmation_number":"PB12211338515","room_confirmation_number":"PB12320999864","room_stay_from":"2019-09-16","room_stay_to":"2019-09-21","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":"86914","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-30 15:01:26","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86914","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":"2985010","reservation_id":"78127","confirmation_number":"PB12284034098","room_confirmation_number":"PB12361931698","room_stay_from":"2019-09-17","room_stay_to":"2019-09-21","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":"87290","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-06 18:30:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87290","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":"2987196","reservation_id":"78511","confirmation_number":"PB12212424566","room_confirmation_number":"PB12316899458","room_stay_from":"2019-09-19","room_stay_to":"2019-09-23","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":"87561","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-12 01:57: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":"87561","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":"2989801","reservation_id":"78975","confirmation_number":"PB12289431423","room_confirmation_number":"PB12338285712","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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":"87896","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-19 18:39:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87896","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":"2991879","reservation_id":"79590","confirmation_number":"PB12222852515","room_confirmation_number":"PB12393011148","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","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":"88136","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-25 19:40:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88136","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":"2993924","reservation_id":"79982","confirmation_number":"PB12238202952","room_confirmation_number":"PB12341637129","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","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":"88422","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-01 11:39: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":"88422","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":"3001539","reservation_id":"81170","confirmation_number":"PB12210937557","room_confirmation_number":"PB12315502603","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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":"89208","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-21 19:04:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89208","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":"3005065","reservation_id":"81739","confirmation_number":"BP12219887453","room_confirmation_number":"BP12526457719","room_stay_from":"2019-09-19","room_stay_to":"2019-09-21","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":"89607","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-31 12:02:11","reservation_modified_date_time":"2019-07-31 12:02:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89607","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":"3007728","reservation_id":"82144","confirmation_number":"PB12233746777","room_confirmation_number":"PB12363769051","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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":"89891","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-06 19:22:12","reservation_modified_date_time":"2019-08-06 19:22:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89891","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":"3008766","reservation_id":"82313","confirmation_number":"PB12262466410","room_confirmation_number":"PB12386184595","room_stay_from":"2019-09-18","room_stay_to":"2019-09-23","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":"90006","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-09 15:53:09","reservation_modified_date_time":"2019-08-09 15:53:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90006","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":"3014437","reservation_id":"83301","confirmation_number":"BV12250837452","room_confirmation_number":"BV12490276735","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"43072","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-27 19:20:00","reservation_modified_date_time":"2019-08-27 19:20:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"43072","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":"3014952","reservation_id":"81272","confirmation_number":"BV12225151771","room_confirmation_number":"BV12422589775","room_stay_from":"2019-09-11","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 14:55:02","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","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":"3016429","reservation_id":"83633","confirmation_number":"PB12262050890","room_confirmation_number":"PB12343852288","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","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":"91028","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-05 01:41:16","reservation_modified_date_time":"2019-09-05 01:41:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91028","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":"3017965","reservation_id":"83861","confirmation_number":"BP12220591027","room_confirmation_number":"BP12516374308","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"91369","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-10 01:14:43","reservation_modified_date_time":"2019-09-10 01:16:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91369","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":"3018491","reservation_id":"83973","confirmation_number":"PB12222636862","room_confirmation_number":"PB12338299789","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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":"91530","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-12 13:06:10","reservation_modified_date_time":"2019-09-12 13:06:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91530","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":"3019252","reservation_id":"79395","confirmation_number":"PB12281772603","room_confirmation_number":"PB12386303594","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","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":"88007","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-22 18:06:59","reservation_modified_date_time":"2019-09-14 18:50:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88007","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":"3019679","reservation_id":"79861","confirmation_number":"PB12256121090","room_confirmation_number":"PB12322920894","room_stay_from":"2019-09-15","room_stay_to":"2019-09-22","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":"70722","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-29 14:29:37","reservation_modified_date_time":"2019-09-15 18:48:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70722","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":"3019888","reservation_id":"83945","confirmation_number":"BP12255020610","room_confirmation_number":"BP12513731838","room_stay_from":"2019-09-14","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"91507","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-14 12:26:08","reservation_modified_date_time":"2019-09-16 14:58:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91507","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":"3019917","reservation_id":"81671","confirmation_number":"PB12236863945","room_confirmation_number":"PB12372254241","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"89546","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-29 18:55:50","reservation_modified_date_time":"2019-09-16 15:31:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89546","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":"3020121","reservation_id":"84218","confirmation_number":"PB12219536770","room_confirmation_number":"PB12339418230","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91704","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-16 20:02:10","reservation_modified_date_time":"2019-09-16 20:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91704","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":"3020202","reservation_id":"84238","confirmation_number":"PB12248548345","room_confirmation_number":"PB12364493384","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"91724","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-17 04:37:09","reservation_modified_date_time":"2019-09-17 04:37:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91724","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":"3020302","reservation_id":"80513","confirmation_number":"PB12233458921","room_confirmation_number":"PB12332832253","room_stay_from":"2019-09-17","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"88789","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-10 23:37:23","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88789","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":"3020466","reservation_id":"84268","confirmation_number":"PB12266002323","room_confirmation_number":"PB12322648139","room_stay_from":"2019-09-19","room_stay_to":"2019-09-21","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"91752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-17 23:41:02","reservation_modified_date_time":"2019-09-18 01:32:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91752","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":"3020515","reservation_id":"84175","confirmation_number":"BP12212181643","room_confirmation_number":"BP12592277240","room_stay_from":"2019-09-16","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"90858","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-16 00:48:17","reservation_modified_date_time":"2019-09-18 13:00:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90858","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":"3020626","reservation_id":"84310","confirmation_number":"PB12211028989","room_confirmation_number":"PB12312554000","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91731","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 15:08:25","reservation_modified_date_time":"2019-09-18 15:08:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91731","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":"3020657","reservation_id":"84317","confirmation_number":"BV12227818725","room_confirmation_number":"BV12488856491","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91791","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 16:57:06","reservation_modified_date_time":"2019-09-18 16:57:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91791","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":"3020663","reservation_id":"83876","confirmation_number":"BP12236647937","room_confirmation_number":"BP12585438690","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","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":"91382","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-10 16:52:56","reservation_modified_date_time":"2019-09-18 17:02:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91382","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":"3020741","reservation_id":"81292","confirmation_number":"PB12244842838","room_confirmation_number":"PB12334530932","room_stay_from":"2019-09-09","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,12.00,12.00,12.00,12.00","subtotal":"132.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"89302","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 20:36:04","reservation_modified_date_time":"2019-09-18 20:03:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89302","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"12.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020750","reservation_id":"84309","confirmation_number":"PB12256778909","room_confirmation_number":"PB12346549641","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91784","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 15:03:11","reservation_modified_date_time":"2019-09-18 20:46:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91784","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":"3020802","reservation_id":"84320","confirmation_number":"BP12226215813","room_confirmation_number":"BP12575460058","room_stay_from":"2019-09-18","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91793","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 17:37:11","reservation_modified_date_time":"2019-09-18 17:37:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91793","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":"3020897","reservation_id":"84189","confirmation_number":"BP12238466017","room_confirmation_number":"BP12533228007","room_stay_from":"2019-09-16","room_stay_to":"2019-09-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"91477","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-16 13:18:30","reservation_modified_date_time":"2019-09-18 17:48:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91477","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":"3020927","reservation_id":"84353","confirmation_number":"PB12246354557","room_confirmation_number":"PB12381669453","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91822","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 17:17:41","reservation_modified_date_time":"2019-09-19 17:17:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91822","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":"3020973","reservation_id":"84347","confirmation_number":"PB12224778307","room_confirmation_number":"PB12383777761","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"91816","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-19 13:33:13","reservation_modified_date_time":"2019-09-19 13:33:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91816","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":"3020975","reservation_id":"84364","confirmation_number":"PB12282816041","room_confirmation_number":"PB12335667024","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"70297","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 18:38:38","reservation_modified_date_time":"2019-09-19 18:38:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70297","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":"3020985","reservation_id":"84367","confirmation_number":"BP12294357759","room_confirmation_number":"BP12581858957","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"91832","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-19 18:54:12","reservation_modified_date_time":"2019-09-19 18:54:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91832","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":"3020987","reservation_id":"57204","confirmation_number":"PB12390168004","room_confirmation_number":"PB12334544524","room_stay_from":"2019-09-19","room_stay_to":"2019-09-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"31302","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-09-27 19:19:09","reservation_modified_date_time":"2019-09-19 19:14:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"31302","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":"3021005","reservation_id":"84363","confirmation_number":"PB12251916445","room_confirmation_number":"PB12320356960","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91830","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 18:24:34","reservation_modified_date_time":"2019-09-19 19:49:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91830","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":"3021082","reservation_id":"84393","confirmation_number":"BP12255073075","room_confirmation_number":"BP12520574202","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91846","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-20 00:44:36","reservation_modified_date_time":"2019-09-20 00:44:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91846","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":"3028483","reservation_id":"84374","confirmation_number":"BP12240142779","room_confirmation_number":"BP12572688457","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91838","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 20:15:46","reservation_modified_date_time":"2019-10-14 23:23:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91838","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":"3028599","reservation_id":"84295","confirmation_number":"PB12219168519","room_confirmation_number":"PB12328331395","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"91773","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 12:18:52","reservation_modified_date_time":"2019-10-15 14:44:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91773","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":"3028629","reservation_id":"84352","confirmation_number":"PB12216017174","room_confirmation_number":"PB12313282734","room_stay_from":"2019-09-19","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89644","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 17:13:57","reservation_modified_date_time":"2019-10-15 15:09:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89644","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":"3017959","reservation_id":"83861","confirmation_number":"BP12247883045","room_confirmation_number":"BP12516374308","room_stay_from":"2019-09-19","room_stay_to":"2019-09-22","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-09-10 01:15:02","reservation_modified_date_time":"2019-09-10 01:15:02","customer_id":"91369","parentCustTravId":"91369","customer_traveller_id":"91369","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":"3020924","reservation_id":"84352","confirmation_number":"PB12264346993","room_confirmation_number":"PB12313282734","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-09-19 17:13:57","reservation_modified_date_time":"2019-09-19 17:13:57","customer_id":"89644","parentCustTravId":"89644","customer_traveller_id":"89644","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":"3020961","reservation_id":"84361","confirmation_number":"BV12257439837","room_confirmation_number":"BV12471019410","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"28.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1212","service_quantity":"3","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-19 18:18:31","reservation_modified_date_time":"2019-09-19 18:18:31","customer_id":"91829","parentCustTravId":"91829","customer_traveller_id":"91829","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":"84.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3020991","reservation_id":"84368","confirmation_number":"BP12246780854","room_confirmation_number":"BP12586917022","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":"84.75","paid_amount":"84.75","product_id":"1146","service_quantity":"3","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-19 19:19:15","reservation_modified_date_time":"2019-09-19 19:19:15","customer_id":"91833","parentCustTravId":"91833","customer_traveller_id":"91833","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":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3021027","reservation_id":"84374","confirmation_number":"BP12247231772","room_confirmation_number":"BP12572688457","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-19 20:35:16","reservation_modified_date_time":"2019-09-19 20:35:16","customer_id":"91838","parentCustTravId":"91838","customer_traveller_id":"91838","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3021091","reservation_id":"84352","confirmation_number":"PB12298347131","room_confirmation_number":"PB12313282734","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-20 01:13:07","reservation_modified_date_time":"2019-09-20 01:13:07","customer_id":"89644","parentCustTravId":"89644","customer_traveller_id":"89644","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3021001","reservation_id":"84371","confirmation_number":"PB12297419279","room_confirmation_number":"PB12388701272","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":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-19 19:29:08","reservation_modified_date_time":"2019-09-19 19:29:08","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}