{"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":13,"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":"3005328","reservation_id":"81792","confirmation_number":"PB12311733722","room_stay_from":"2019-09-20","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.27,125.27,113.83,113.83","nightly_discount":"0,0,0,0","subtotal":"478.20","grand_total":"540.36","paid_amount":"540.36","room_type_id":"289","product_id":"1104","siteminder_id":"BDC-2539762780","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":"89648","customer_id":"89648","source_of_creation":"Booking.com","reservation_created_date":"2019-08-01 00:27:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"71.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.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":"3022195","reservation_id":"84620","confirmation_number":"PB12378676250","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.95","nightly_discount":"0","subtotal":"69.95","grand_total":"79.05","paid_amount":"79.05","room_type_id":"290","product_id":"1113","siteminder_id":"BDC-2973688896","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":"91955","customer_id":"91955","source_of_creation":"Booking.com","reservation_created_date":"2019-09-23 21:08:10","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"10.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.95","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":[{"room_stay_id":"3017532","reservation_id":"83791","confirmation_number":"PB12358874591","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.33,110.33","nightly_discount":"0,0","subtotal":"220.66","grand_total":"249.35","paid_amount":"124.67","room_type_id":"292","product_id":"1120","siteminder_id":"BDC-2768601364","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":"91136","customer_id":"91136","source_of_creation":"Booking.com","reservation_created_date":"2019-09-08 18:26:09","service_canceled_date_time":"2019-09-20 19:25:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"33.10","deltaChange":"124.67","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3022244","reservation_id":"84627","confirmation_number":"PB12338024756","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.20,92.20","nightly_discount":"0,0","subtotal":"184.40","grand_total":"208.37","paid_amount":"208.37","room_type_id":"291","product_id":"1117","siteminder_id":"BDC-2471836784","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":"91962","customer_id":"91962","source_of_creation":"Booking.com","reservation_created_date":"2019-09-24 00:20:12","service_canceled_date_time":"2019-09-24 00:56:29","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"27.66","deltaChange":"208.37","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3004752","reservation_id":"81700","confirmation_number":"PB12340192578","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16,86.16,86.16,86.16","nightly_discount":"0,0,0,0","subtotal":"344.64","grand_total":"389.44","paid_amount":"389.44","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1311201865","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":"89571","customer_id":"89571","source_of_creation":"Expedia","reservation_created_date":"2019-07-30 12:37:08","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":"86.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3012751","reservation_id":"83029","confirmation_number":"PB12318388398","room_stay_from":"2019-09-22","room_stay_to":"2019-09-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.01,84.01,84.01,84.01,84.01,92.45,92.45","nightly_discount":"0,0,0,0,0,0,0","subtotal":"604.95","grand_total":"683.60","paid_amount":"683.60","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1326914193","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":"90486","customer_id":"90486","source_of_creation":"Expedia","reservation_created_date":"2019-08-22 01:17: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":"84.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":"3013669","reservation_id":"82739","confirmation_number":"PB12389315849","room_stay_from":"2019-09-21","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.27,113.83,113.83","nightly_discount":"0,0,0","subtotal":"352.93","grand_total":"398.82","paid_amount":"398.82","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1323209644","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":"90287","customer_id":"90287","source_of_creation":"Expedia","reservation_created_date":"2019-08-16 14:47:10","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":"113.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":"3014637","reservation_id":"83350","confirmation_number":"PB12367134751","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,113.83","nightly_discount":"0,0","subtotal":"227.66","grand_total":"257.26","paid_amount":"257.26","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1331276414","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":"90715","customer_id":"90715","source_of_creation":"Expedia","reservation_created_date":"2019-08-28 18:21:15","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":"113.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":"3020762","reservation_id":"84332","confirmation_number":"PB12324192589","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.61","nightly_discount":"0","subtotal":"75.61","grand_total":"85.44","paid_amount":"85.44","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1345175789","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":"91803","customer_id":"91803","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 21:57:07","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":"75.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021921","reservation_id":"84285","confirmation_number":"PB12332585816","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.01,84.01","nightly_discount":"0,0","subtotal":"168.02","grand_total":"189.86","paid_amount":"189.86","room_type_id":"289","product_id":"1110","siteminder_id":"EXP-1344556522","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":"91764","customer_id":"91764","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 00:52:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.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":"3021932","reservation_id":"84538","confirmation_number":"PB12395781536","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.01,84.01","nightly_discount":"0,0","subtotal":"168.02","grand_total":"189.86","paid_amount":"189.86","room_type_id":"289","product_id":"1108","siteminder_id":"EXP-1347471638","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":"91913","customer_id":"91913","source_of_creation":"Expedia","reservation_created_date":"2019-09-22 18:07:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3021891","reservation_id":"81809","confirmation_number":"PB12344051789","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.99,43.39,43.39,43.39","nightly_discount":"0.00,0.00,0.00,4.52,0.00","subtotal":"187.16","grand_total":"206.38","paid_amount":"206.38","room_type_id":"285","product_id":"1085","siteminder_id":"HTN-94033237-2TAWRN","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":"89654","customer_id":"89654","source_of_creation":"HotelTonight","reservation_created_date":"2019-08-01 06:25:05","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":"43.39","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3021533","reservation_id":"84148","confirmation_number":"PB12329343627","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.02,91.73,114.67","nightly_discount":"0.00,0.00,0.00","subtotal":"281.42","grand_total":"318.01","paid_amount":"0.00","room_type_id":"313","product_id":"1228","siteminder_id":"GAM-R1662112087","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":"91647","customer_id":"91647","source_of_creation":"Getaroom.com","reservation_created_date":"2019-09-15 18:43:09","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":"91.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3021912","reservation_id":"84482","confirmation_number":"PB12336675317","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.32,68.32,68.32","nightly_discount":"0.00,0.00,0.00","subtotal":"204.96","grand_total":"231.61","paid_amount":"231.61","room_type_id":"289","product_id":"1109","siteminder_id":"AGO-281643350","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91890","customer_id":"91890","source_of_creation":"Agoda","reservation_created_date":"2019-09-21 18:51:10","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":"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":"3022112","reservation_id":"84610","confirmation_number":"PB12372192841","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60,70.60","nightly_discount":"0,0","subtotal":"141.20","grand_total":"159.55","paid_amount":"159.55","room_type_id":"289","product_id":"1103","siteminder_id":"AGO-281930622","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":"88174","customer_id":"88174","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 17:51:10","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":"70.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022159","reservation_id":"84612","confirmation_number":"PB12375761859","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60","nightly_discount":"0","subtotal":"70.60","grand_total":"79.78","paid_amount":"79.78","room_type_id":"291","product_id":"1118","siteminder_id":"AGO-281930634","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":"91949","customer_id":"91949","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 17:51:23","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":"70.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022223","reservation_id":"84621","confirmation_number":"PB12317827454","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"75.34","nightly_discount":"0.00","subtotal":"75.34","grand_total":"85.13","paid_amount":"85.13","room_type_id":"292","product_id":"1120","siteminder_id":"AGO-281966342","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91956","customer_id":"91956","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 21:21:09","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":"75.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022253","reservation_id":"84625","confirmation_number":"PB12350858624","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.85","nightly_discount":"0.00","subtotal":"77.85","grand_total":"87.97","paid_amount":"87.97","room_type_id":"304","product_id":"1219","siteminder_id":"AGO-281990270","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":"91960","customer_id":"91960","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 23:39:10","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":"77.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[{"room_stay_id":"3022114","reservation_id":"84611","confirmation_number":"PB12338979454","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60,70.60","nightly_discount":"0,0","subtotal":"141.20","grand_total":"159.55","paid_amount":"159.55","room_type_id":"289","product_id":"1111","siteminder_id":"AGO-281930630","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":"91948","customer_id":"91948","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 17:51:16","service_canceled_date_time":"2019-09-23 23:14:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"159.55","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"fe_taxable":[{"room_stay_id":"2986813","reservation_id":"78417","confirmation_number":"PB12361011111","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00","subtotal":"357.60","grand_total":"404.09","paid_amount":"404.09","room_type_id":"291","product_id":"1114","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":"87484","customer_id":"87484","source_of_creation":"FE","reservation_created_date":"2019-06-10 16:32:42","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":"119.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":"3021906","reservation_id":"84306","confirmation_number":"PB12390885233","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,22.61,0.00","subtotal":"520.00","grand_total":"562.05","paid_amount":"562.05","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90237","customer_id":"90237","source_of_creation":"FE","reservation_created_date":"2019-09-18 14:46:15","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3022187","reservation_id":"83385","confirmation_number":"PB12321432779","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"82.56,82.56","nightly_discount":"0.00,0.00","subtotal":"165.12","grand_total":"186.59","paid_amount":"186.59","room_type_id":"286","product_id":"1086","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":"89974","customer_id":"89974","source_of_creation":"FE","reservation_created_date":"2019-08-29 13:48:49","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":"82.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3010233","reservation_id":"82597","confirmation_number":"PB12380421202","room_stay_from":"2019-09-21","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.80,160.80,160.80,160.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"659.20","grand_total":"744.89","paid_amount":"744.89","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":"59446","customer_id":"59446","source_of_creation":"PMS","reservation_created_date":"2019-08-14 00:18:17","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":"160.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":"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":"3021251","reservation_id":"57232","confirmation_number":"PB12317021359","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,35.33,0.00","subtotal":"798.00","grand_total":"861.82","paid_amount":"861.82","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70002","customer_id":"70002","source_of_creation":"PMS","reservation_created_date":"2018-09-28 12:21:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021411","reservation_id":"70858","confirmation_number":"PB12399611650","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,120.00,120.00,120.00,120.00,120.00","nightly_discount":"41.70,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"947.28","paid_amount":"947.28","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44540","customer_id":"44540","source_of_creation":"PMS","reservation_created_date":"2019-03-03 20:12:26","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021433","reservation_id":"57205","confirmation_number":"PB12352404720","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"805.00","grand_total":"909.65","paid_amount":"909.65","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":"23334","customer_id":"23334","source_of_creation":"PMS","reservation_created_date":"2018-09-27 19:22:16","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":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021536","reservation_id":"57222","confirmation_number":"PB12310106429","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"8.80,0.00,0.00,0.00,0.00,0.00,39.79,0.00","subtotal":"805.00","grand_total":"854.74","paid_amount":"854.74","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":"36512","customer_id":"36512","source_of_creation":"PMS","reservation_created_date":"2018-09-27 23:00:04","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":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021596","reservation_id":"80270","confirmation_number":"PB12369786647","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00,96.00,96.00,96.00,96.00,96.00,112.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"704.00","grand_total":"795.52","paid_amount":"795.52","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":"88617","customer_id":"88617","source_of_creation":"PMS","reservation_created_date":"2019-07-06 01:06:26","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":"3021777","reservation_id":"80272","confirmation_number":"PB12388926914","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"112.00,96.00,96.00,96.00,96.00,96.00,112.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,38.04,0.00","subtotal":"704.00","grand_total":"752.54","paid_amount":"752.54","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":"88617","customer_id":"88617","source_of_creation":"PMS","reservation_created_date":"2019-07-06 01:09:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3021930","reservation_id":"82982","confirmation_number":"PB12334539082","room_stay_from":"2019-09-23","room_stay_to":"2019-09-26","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":"291","product_id":"1115","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":"90450","customer_id":"90450","source_of_creation":"PMS","reservation_created_date":"2019-08-20 23:00:40","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3022027","reservation_id":"84595","confirmation_number":"PB12378673386","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"102.00","nightly_discount":"0.00","subtotal":"102.00","grand_total":"115.26","paid_amount":"115.26","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":"91935","customer_id":"91935","source_of_creation":"PMS","reservation_created_date":"2019-09-23 13:32:05","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":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022145","reservation_id":"76357","confirmation_number":"PB12375826026","room_stay_from":"2019-09-23","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,201.00","nightly_discount":"0.00,0.00,0.00,32.42,0.00","subtotal":"804.00","grand_total":"871.88","paid_amount":"871.89","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85977","customer_id":"85977","source_of_creation":"PMS","reservation_created_date":"2019-05-13 16:46:14","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":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022396","reservation_id":"84663","confirmation_number":"PB12379580601","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60,70.60","nightly_discount":"0.00,0.00","subtotal":"141.20","grand_total":"159.55","paid_amount":"159.55","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88174","customer_id":"88174","source_of_creation":"PMS","reservation_created_date":"2019-09-24 21:48:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.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":"3024869","reservation_id":"80196","confirmation_number":"PB12332838153","room_stay_from":"2019-09-23","room_stay_to":"2019-10-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.80,148.80,148.80,148.80,164.80,164.80,148.80,148.80,148.80,148.80,148.80,164.80,164.80,148.80,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2236.20","grand_total":"2526.90","paid_amount":"2526.90","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":"48600","customer_id":"48600","source_of_creation":"PMS","reservation_created_date":"2019-07-04 22:48:30","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":"3026140","reservation_id":"82151","confirmation_number":"PB12314254400","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00","nightly_discount":"0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89896","customer_id":"89896","source_of_creation":"PMS","reservation_created_date":"2019-08-06 20:44:04","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028618","reservation_id":"84256","confirmation_number":"PB12327025728","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91739","customer_id":"91739","source_of_creation":"PMS","reservation_created_date":"2019-09-17 17:04:39","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":"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":"3028675","reservation_id":"81834","confirmation_number":"PB12329074584","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","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":"289","product_id":"1097","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":"89676","customer_id":"89676","source_of_creation":"PMS","reservation_created_date":"2019-08-01 17:54:40","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","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":"2996093","reservation_id":"74909","confirmation_number":"PB12311097502","room_stay_from":"2019-09-20","room_stay_to":"2019-09-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.80,176.80,160.80","nightly_discount":"0.00,0.00,0.00","subtotal":"514.40","grand_total":"581.27","paid_amount":"581.27","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58691","customer_id":"58691","source_of_creation":"PMS","reservation_created_date":"2019-04-18 12:52:41","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":"","changedComment":"Nightly price or discount changed","deltaChange":"170.40","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3012359","reservation_id":"82981","confirmation_number":"PB12351896731","room_stay_from":"2019-09-23","room_stay_to":"2019-09-26","room_stay_status":"Active","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":"76.84","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90449","customer_id":"90449","source_of_creation":"PMS","reservation_created_date":"2019-08-20 22:45:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":104,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3021608","reservation_id":"80272","confirmation_number":"PB12284245844","room_confirmation_number":"PB12388926914","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"88617","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-21 18:53:11","reservation_modified_date_time":"2019-09-21 18:53:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88617","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022028","reservation_id":"84595","confirmation_number":"PB12265939531","room_confirmation_number":"PB12378673386","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"91935","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-23 13:32:05","reservation_modified_date_time":"2019-09-23 13:32:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91935","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3012360","reservation_id":"82981","confirmation_number":"PB12292734281","room_confirmation_number":"PB12351896731","room_stay_from":"2019-09-23","room_stay_to":"2019-09-26","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-20 22:45:05","reservation_modified_date_time":"2019-08-20 22:45:05","customer_id":"90449","parentCustTravId":"90449","customer_traveller_id":"90449","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#12","currentDayPrice":12,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986814","reservation_id":"78417","confirmation_number":"PB12270451568","room_confirmation_number":"PB12361011111","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","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":"87484","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-10 16:32:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87484","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":"3004753","reservation_id":"81700","confirmation_number":"PB12222283784","room_confirmation_number":"PB12340192578","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","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":"89571","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-30 12:37:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89571","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":"3005329","reservation_id":"81792","confirmation_number":"PB12298485035","room_confirmation_number":"PB12311733722","room_stay_from":"2019-09-20","room_stay_to":"2019-09-24","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":"89648","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-01 00:27:11","reservation_modified_date_time":"2019-08-01 00:27:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89648","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":"3010234","reservation_id":"82597","confirmation_number":"PB12267095179","room_confirmation_number":"PB12380421202","room_stay_from":"2019-09-21","room_stay_to":"2019-09-25","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":"59446","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-14 00:18:17","reservation_modified_date_time":"2019-08-14 00:18:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59446","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":"3012752","reservation_id":"83029","confirmation_number":"PB12248947952","room_confirmation_number":"PB12318388398","room_stay_from":"2019-09-22","room_stay_to":"2019-09-29","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"90486","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-22 01:17:08","reservation_modified_date_time":"2019-08-22 01:17:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90486","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":"3013670","reservation_id":"82739","confirmation_number":"PB12257915353","room_confirmation_number":"PB12389315849","room_stay_from":"2019-09-21","room_stay_to":"2019-09-24","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":"90287","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-16 14:47:10","reservation_modified_date_time":"2019-08-16 14:47:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90287","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":"3014638","reservation_id":"83350","confirmation_number":"PB12253960548","room_confirmation_number":"PB12367134751","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"90715","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-28 18:21:15","reservation_modified_date_time":"2019-08-28 18:21:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90715","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":"3020763","reservation_id":"84332","confirmation_number":"PB12275205755","room_confirmation_number":"PB12324192589","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91803","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 21:57:07","reservation_modified_date_time":"2019-09-18 21:57:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91803","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":"3021252","reservation_id":"57232","confirmation_number":"PB12337445687","room_confirmation_number":"PB12317021359","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"70002","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-09-28 12:23:59","reservation_modified_date_time":"2019-09-20 20:13:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70002","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":"3021412","reservation_id":"70858","confirmation_number":"PB12242814831","room_confirmation_number":"PB12399611650","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","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":"44540","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-03 20:12:26","reservation_modified_date_time":"2019-09-21 02:48:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44540","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":"3021434","reservation_id":"57205","confirmation_number":"PB12354066679","room_confirmation_number":"PB12352404720","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23334","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-09-27 19:22:22","reservation_modified_date_time":"2019-09-21 02:53:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23334","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":"3021534","reservation_id":"84148","confirmation_number":"PB12246622874","room_confirmation_number":"PB12329343627","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","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":"91647","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-15 18:43:09","reservation_modified_date_time":"2019-09-21 15:14:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91647","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":"3021537","reservation_id":"57222","confirmation_number":"PBR12216614344","room_confirmation_number":"PB12310106429","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","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":"36512","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-09-21 15:49:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36512","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":"3021597","reservation_id":"80270","confirmation_number":"PB12281708148","room_confirmation_number":"PB12369786647","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","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":"88617","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-06 01:06:26","reservation_modified_date_time":"2019-09-21 18:49:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88617","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":"3021778","reservation_id":"80272","confirmation_number":"PB12269193891","room_confirmation_number":"PB12388926914","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","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":"88617","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-06 01:09:05","reservation_modified_date_time":"2019-09-22 02:11:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88617","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":"3021892","reservation_id":"81809","confirmation_number":"PB12226574470","room_confirmation_number":"PB12344051789","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","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":"89654","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-01 06:25:05","reservation_modified_date_time":"2019-09-22 17:32:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89654","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":"3021907","reservation_id":"84306","confirmation_number":"PB12292524337","room_confirmation_number":"PB12390885233","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","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":"90237","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 14:46:15","reservation_modified_date_time":"2019-09-22 18:38:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90237","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":"3021914","reservation_id":"84482","confirmation_number":"PB12261869534","room_confirmation_number":"PB12336675317","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","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":"91890","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-21 18:51:10","reservation_modified_date_time":"2019-09-22 18:46:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91890","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":"3021922","reservation_id":"84285","confirmation_number":"PB12271404593","room_confirmation_number":"PB12332585816","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","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":"91764","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 00:52:09","reservation_modified_date_time":"2019-09-18 00:52:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91764","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":"3021931","reservation_id":"82982","confirmation_number":"PB12269411632","room_confirmation_number":"PB12334539082","room_stay_from":"2019-09-23","room_stay_to":"2019-09-26","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":"90450","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-20 23:00:40","reservation_modified_date_time":"2019-08-20 23:00:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90450","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":"3021933","reservation_id":"84538","confirmation_number":"PB12214483534","room_confirmation_number":"PB12395781536","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","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":"91913","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-22 18:07:07","reservation_modified_date_time":"2019-09-22 18:07:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91913","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":"3022029","reservation_id":"84595","confirmation_number":"PB12263998303","room_confirmation_number":"PB12378673386","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91935","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-23 13:32:05","reservation_modified_date_time":"2019-09-23 13:32:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91935","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":"3022113","reservation_id":"84610","confirmation_number":"PB12222809096","room_confirmation_number":"PB12372192841","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"88174","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 17:51:10","reservation_modified_date_time":"2019-09-23 17:51:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88174","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":"3022146","reservation_id":"76357","confirmation_number":"PB12249803042","room_confirmation_number":"PB12375826026","room_stay_from":"2019-09-23","room_stay_to":"2019-09-27","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":"85977","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-13 16:46:14","reservation_modified_date_time":"2019-09-23 19:33:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85977","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":"3022160","reservation_id":"84612","confirmation_number":"PB12268749554","room_confirmation_number":"PB12375761859","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91949","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 17:51:23","reservation_modified_date_time":"2019-09-23 17:51:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91949","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":"3022188","reservation_id":"83385","confirmation_number":"PB12295846343","room_confirmation_number":"PB12321432779","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"89974","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 13:48:49","reservation_modified_date_time":"2019-08-29 13:48:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89974","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":"3022196","reservation_id":"84620","confirmation_number":"PB12279557605","room_confirmation_number":"PB12378676250","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91955","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 21:08:10","reservation_modified_date_time":"2019-09-23 21:08:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91955","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":"3022225","reservation_id":"84621","confirmation_number":"PB12249982567","room_confirmation_number":"PB12317827454","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91956","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 21:21:09","reservation_modified_date_time":"2019-09-23 23:08:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91956","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":"3022254","reservation_id":"84625","confirmation_number":"PB12251311793","room_confirmation_number":"PB12350858624","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91960","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 23:39:10","reservation_modified_date_time":"2019-09-24 01:16:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91960","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":"3024870","reservation_id":"80196","confirmation_number":"PB12223524481","room_confirmation_number":"PB12332838153","room_stay_from":"2019-09-23","room_stay_to":"2019-10-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"48600","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-04 22:48:30","reservation_modified_date_time":"2019-10-03 13:25:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48600","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":"3028619","reservation_id":"84256","confirmation_number":"PB12255048723","room_confirmation_number":"PB12327025728","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91739","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-17 17:04:39","reservation_modified_date_time":"2019-10-15 15:00:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91739","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":"3028676","reservation_id":"81834","confirmation_number":"PB12277301453","room_confirmation_number":"PB12329074584","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","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":"89676","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-01 17:54:40","reservation_modified_date_time":"2019-10-15 16:47:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89676","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":"3022102","reservation_id":"81809","confirmation_number":"PB12288989344","room_confirmation_number":"PB12344051789","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.26","grand_total":"3.49","paid_amount":"3.49","product_id":"1206","service_quantity":"1","product_name":"Toothpaste","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 16:58:04","reservation_modified_date_time":"2019-09-23 16:58:04","customer_id":"89654","parentCustTravId":"89654","customer_traveller_id":"89654","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":"3.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3022111","reservation_id":"83350","confirmation_number":"PB12228336341","room_confirmation_number":"PB12367134751","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 17:31:38","reservation_modified_date_time":"2019-09-23 17:31:38","customer_id":"90715","parentCustTravId":"90715","customer_traveller_id":"90715","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":"3022189","reservation_id":"83385","confirmation_number":"PB12273387423","room_confirmation_number":"PB12321432779","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":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 20:51:58","reservation_modified_date_time":"2019-09-23 20:51:58","customer_id":"89974","parentCustTravId":"89974","customer_traveller_id":"89974","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":"3022190","reservation_id":"83385","confirmation_number":"PB12237801578","room_confirmation_number":"PB12321432779","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":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 20:52:14","reservation_modified_date_time":"2019-09-23 20:52:14","customer_id":"89974","parentCustTravId":"89974","customer_traveller_id":"89974","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":"3022032","reservation_id":"84597","confirmation_number":"PB12256908086","room_confirmation_number":"PB12387827607","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 13:48:08","reservation_modified_date_time":"2019-09-23 13:48: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":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3014536","reservation_id":"83333","confirmation_number":"PB12269761524","room_confirmation_number":"PB12376448583","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-28 12:42:55","reservation_modified_date_time":"2019-08-28 12:42:55","customer_id":"90701","parentCustTravId":"90701","customer_traveller_id":"90701","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-24 01:54:21","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3021939","reservation_id":"84485","confirmation_number":"BV12442618316","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.18,68.18,68.18,68.18,68.18","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"340.90","grand_total":"385.21","paid_amount":"385.21","room_type_id":"304","product_id":"1218","siteminder_id":"AGO-281650290","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":"49057","customer_id":"49057","source_of_creation":"Agoda","reservation_created_date":"2019-09-21 19:39:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_taxable":[{"room_stay_id":"3005038","reservation_id":"81733","confirmation_number":"BV12419926335","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"110.88,110.88","nightly_discount":"0.00,0.00","subtotal":"221.76","grand_total":"250.59","paid_amount":"250.59","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":"89602","customer_id":"89602","source_of_creation":"FE","reservation_created_date":"2019-07-31 02:39:45","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"}]}],"fe_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3005039","reservation_id":"81733","confirmation_number":"BV12297199009","room_confirmation_number":"BV12419926335","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"89602","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-31 02:39:45","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89602","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":"3021940","reservation_id":"84485","confirmation_number":"BV12281247629","room_confirmation_number":"BV12442618316","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91893","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-21 19:39:10","reservation_modified_date_time":"2019-09-22 21:01:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"49057","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_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":1,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"exp_taxable":[{"room_stay_id":"3007711","reservation_id":"82139","confirmation_number":"BP12594684570","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.79,60.79","nightly_discount":"0,0","subtotal":"121.58","grand_total":"137.38","paid_amount":"137.38","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1316363268","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":"89885","customer_id":"89885","source_of_creation":"Expedia","reservation_created_date":"2019-08-06 18:32:08","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":"60.79","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020726","reservation_id":"84325","confirmation_number":"BP12543179698","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","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":"295","product_id":"1129","siteminder_id":"EXP-1345094665","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":"91797","customer_id":"91797","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 19:32:10","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":"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_taxable":[{"room_stay_id":"3021860","reservation_id":"84530","confirmation_number":"BP12573497633","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.86,48.86","nightly_discount":"0,0","subtotal":"97.72","grand_total":"110.42","paid_amount":"110.42","room_type_id":"293","product_id":"1124","siteminder_id":"GAM-R1672043527","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":"91908","customer_id":"91908","source_of_creation":"Getaroom.com","reservation_created_date":"2019-09-22 14:19:08","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.86","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[{"room_stay_id":"3021978","reservation_id":"81483","confirmation_number":"BP12567026140","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.1,62.1,62.1,62.1,62.1","nightly_discount":"0,0,0,0,0","subtotal":"310.50","grand_total":"350.87","paid_amount":"350.87","room_type_id":"304","product_id":"1221","siteminder_id":"ZOO-6659-1678-6797","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":"89423","customer_id":"89423","source_of_creation":"Travelzoo","reservation_created_date":"2019-07-26 17:11:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.1","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"}]}],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3002050","reservation_id":"81237","confirmation_number":"BP12521273972","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"77.60,77.60,77.60","nightly_discount":"0,0,0","subtotal":"232.80","grand_total":"303.74","paid_amount":"303.74","room_type_id":"299","product_id":"1134","siteminder_id":"ABB-HMAH2Y2QCM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"232.80","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89257","customer_id":"89257","source_of_creation":"Airbnb","reservation_created_date":"2019-07-23 00:06:05","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"32.54","commision_charges":"7.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3021692","reservation_id":"84498","confirmation_number":"BP12524591461","room_stay_from":"2019-09-22","room_stay_to":"2019-09-23","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"83.82","nightly_discount":"0","subtotal":"83.82","grand_total":"94.72","paid_amount":"0.00","room_type_id":"301","product_id":"1136","siteminder_id":"HWR-300991062","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91897","customer_id":"91897","source_of_creation":"Hotwire","reservation_created_date":"2019-09-21 22:52:11","service_canceled_date_time":"2019-09-23 14:09:09","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":-83.82,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[{"room_stay_id":"3021986","reservation_id":"84555","confirmation_number":"BP12511402935","room_stay_from":"2019-09-22","room_stay_to":"2019-09-23","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.87","nightly_discount":"0","subtotal":"51.87","grand_total":"58.61","paid_amount":"58.61","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-300995559","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":"91927","customer_id":"91927","source_of_creation":"Hotwire","reservation_created_date":"2019-09-23 01:44:06","service_canceled_date_time":"2019-09-23 01:54:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"6.74","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"gcc_taxable":[],"gcc_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3022213","reservation_id":"81031","confirmation_number":"BP12541933890","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.60,93.60,93.60,93.60,109.60,109.60,93.60,93.60,93.60,93.60,93.60,109.60,109.60,93.60,93.60,93.60,93.60,93.60,93.60,93.60,93.60","nightly_discount":"86.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2029.60","grand_total":"2195.37","paid_amount":"2195.37","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":"89141","customer_id":"89141","source_of_creation":"PMS","reservation_created_date":"2019-07-19 19:58:46","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":"","currentDayPrice":"93.60","currentDayDiscount":"86.80","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022219","reservation_id":"57926","confirmation_number":"BP12530019332","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"99.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2079.00","grand_total":"2237.40","paid_amount":"2237.40","room_type_id":"296","product_id":"1131","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58813","customer_id":"58813","source_of_creation":"PMS","reservation_created_date":"2018-10-09 15:24:13","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"99.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3021693","reservation_id":"84498","confirmation_number":"BP12299190252","room_confirmation_number":"BP12524591461","room_stay_from":"2019-09-22","room_stay_to":"2019-09-23","room_stay_status":"Canceled","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-22 00:35:02","reservation_modified_date_time":"2019-09-22 00:35:02","customer_id":"91897","parentCustTravId":"91897","customer_traveller_id":"91897","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-23 14:09:09","canceled_nights_data":"","product_attribute_values":"extra_person#&#10","deltaChange":-10,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3002051","reservation_id":"81237","confirmation_number":"BP12250492060","room_confirmation_number":"BP12521273972","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","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":"89257","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-23 00:06:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89257","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3007712","reservation_id":"82139","confirmation_number":"BP12254267182","room_confirmation_number":"BP12594684570","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"89885","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-06 18:32:08","reservation_modified_date_time":"2019-08-06 18:32:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89885","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":"3020727","reservation_id":"84325","confirmation_number":"BP12229027118","room_confirmation_number":"BP12543179698","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","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":"91797","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 19:32:10","reservation_modified_date_time":"2019-09-18 19:32:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91797","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":"3021861","reservation_id":"84530","confirmation_number":"BP12216512877","room_confirmation_number":"BP12573497633","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"91908","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-22 14:19:08","reservation_modified_date_time":"2019-09-22 14:19:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91908","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":"3021979","reservation_id":"81483","confirmation_number":"BP12210631270","room_confirmation_number":"BP12567026140","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","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":"89423","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-26 17:11:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89423","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":"3022214","reservation_id":"81031","confirmation_number":"BP12246988669","room_confirmation_number":"BP12541933890","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89141","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-19 19:58:46","reservation_modified_date_time":"2019-09-23 22:48:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89141","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":"3022220","reservation_id":"57926","confirmation_number":"BP12547187980","room_confirmation_number":"BP12530019332","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"58813","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-10-09 15:24:13","reservation_modified_date_time":"2019-09-23 23:00:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58813","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":"3021694","reservation_id":"84498","confirmation_number":"BP12262679402","room_confirmation_number":"BP12524591461","room_stay_from":"2019-09-22","room_stay_to":"2019-09-23","room_stay_status":"Canceled","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-21 22:52:11","reservation_modified_date_time":"2019-09-21 22:52:11","customer_id":"91897","parentCustTravId":"91897","customer_traveller_id":"91897","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-23 14:09:09","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3022081","reservation_id":"84607","confirmation_number":"BP12272132372","room_confirmation_number":"BP12520615229","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-23 16:00:50","reservation_modified_date_time":"2019-09-23 16:00:50","customer_id":"67859","parentCustTravId":"67859","customer_traveller_id":"67859","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":"3021677","reservation_id":"84498","confirmation_number":"BP12230973691","room_confirmation_number":"BP12524591461","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"100.00","grand_total":"113.00","paid_amount":"0.00","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-21 23:49:50","reservation_modified_date_time":"2019-09-21 23:49:50","customer_id":"91897","parentCustTravId":"91897","customer_traveller_id":"91897","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-23 14:09:09","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-100,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":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-23","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":"3005328","reservation_id":"81792","confirmation_number":"PB12311733722","room_stay_from":"2019-09-20","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.27,125.27,113.83,113.83","nightly_discount":"0,0,0,0","subtotal":"478.20","grand_total":"540.36","paid_amount":"540.36","room_type_id":"289","product_id":"1104","siteminder_id":"BDC-2539762780","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":"89648","customer_id":"89648","source_of_creation":"Booking.com","reservation_created_date":"2019-08-01 00:27:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"71.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.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":"3022195","reservation_id":"84620","confirmation_number":"PB12378676250","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.95","nightly_discount":"0","subtotal":"69.95","grand_total":"79.05","paid_amount":"79.05","room_type_id":"290","product_id":"1113","siteminder_id":"BDC-2973688896","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":"91955","customer_id":"91955","source_of_creation":"Booking.com","reservation_created_date":"2019-09-23 21:08:10","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"10.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.95","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":[{"room_stay_id":"3017532","reservation_id":"83791","confirmation_number":"PB12358874591","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.33,110.33","nightly_discount":"0,0","subtotal":"220.66","grand_total":"249.35","paid_amount":"124.67","room_type_id":"292","product_id":"1120","siteminder_id":"BDC-2768601364","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":"91136","customer_id":"91136","source_of_creation":"Booking.com","reservation_created_date":"2019-09-08 18:26:09","service_canceled_date_time":"2019-09-20 19:25:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"33.10","deltaChange":"124.67","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3022244","reservation_id":"84627","confirmation_number":"PB12338024756","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.20,92.20","nightly_discount":"0,0","subtotal":"184.40","grand_total":"208.37","paid_amount":"208.37","room_type_id":"291","product_id":"1117","siteminder_id":"BDC-2471836784","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":"91962","customer_id":"91962","source_of_creation":"Booking.com","reservation_created_date":"2019-09-24 00:20:12","service_canceled_date_time":"2019-09-24 00:56:29","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"27.66","deltaChange":"208.37","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3004752","reservation_id":"81700","confirmation_number":"PB12340192578","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16,86.16,86.16,86.16","nightly_discount":"0,0,0,0","subtotal":"344.64","grand_total":"389.44","paid_amount":"389.44","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1311201865","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":"89571","customer_id":"89571","source_of_creation":"Expedia","reservation_created_date":"2019-07-30 12:37:08","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":"86.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007711","reservation_id":"82139","confirmation_number":"BP12594684570","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.79,60.79","nightly_discount":"0,0","subtotal":"121.58","grand_total":"137.38","paid_amount":"137.38","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1316363268","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":"89885","customer_id":"89885","source_of_creation":"Expedia","reservation_created_date":"2019-08-06 18:32:08","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":"60.79","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3012751","reservation_id":"83029","confirmation_number":"PB12318388398","room_stay_from":"2019-09-22","room_stay_to":"2019-09-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.01,84.01,84.01,84.01,84.01,92.45,92.45","nightly_discount":"0,0,0,0,0,0,0","subtotal":"604.95","grand_total":"683.60","paid_amount":"683.60","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1326914193","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":"90486","customer_id":"90486","source_of_creation":"Expedia","reservation_created_date":"2019-08-22 01:17: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":"84.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":"3013669","reservation_id":"82739","confirmation_number":"PB12389315849","room_stay_from":"2019-09-21","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.27,113.83,113.83","nightly_discount":"0,0,0","subtotal":"352.93","grand_total":"398.82","paid_amount":"398.82","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1323209644","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":"90287","customer_id":"90287","source_of_creation":"Expedia","reservation_created_date":"2019-08-16 14:47:10","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":"113.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":"3014637","reservation_id":"83350","confirmation_number":"PB12367134751","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,113.83","nightly_discount":"0,0","subtotal":"227.66","grand_total":"257.26","paid_amount":"257.26","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1331276414","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":"90715","customer_id":"90715","source_of_creation":"Expedia","reservation_created_date":"2019-08-28 18:21:15","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":"113.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":"3020726","reservation_id":"84325","confirmation_number":"BP12543179698","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","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":"295","product_id":"1129","siteminder_id":"EXP-1345094665","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":"91797","customer_id":"91797","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 19:32:10","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":"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"}]},{"room_stay_id":"3020762","reservation_id":"84332","confirmation_number":"PB12324192589","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.61","nightly_discount":"0","subtotal":"75.61","grand_total":"85.44","paid_amount":"85.44","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1345175789","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":"91803","customer_id":"91803","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 21:57:07","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":"75.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021921","reservation_id":"84285","confirmation_number":"PB12332585816","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.01,84.01","nightly_discount":"0,0","subtotal":"168.02","grand_total":"189.86","paid_amount":"189.86","room_type_id":"289","product_id":"1110","siteminder_id":"EXP-1344556522","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":"91764","customer_id":"91764","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 00:52:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.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":"3021932","reservation_id":"84538","confirmation_number":"PB12395781536","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.01,84.01","nightly_discount":"0,0","subtotal":"168.02","grand_total":"189.86","paid_amount":"189.86","room_type_id":"289","product_id":"1108","siteminder_id":"EXP-1347471638","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":"91913","customer_id":"91913","source_of_creation":"Expedia","reservation_created_date":"2019-09-22 18:07:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3021891","reservation_id":"81809","confirmation_number":"PB12344051789","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.99,43.39,43.39,43.39","nightly_discount":"0.00,0.00,0.00,4.52,0.00","subtotal":"187.16","grand_total":"206.38","paid_amount":"206.38","room_type_id":"285","product_id":"1085","siteminder_id":"HTN-94033237-2TAWRN","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":"89654","customer_id":"89654","source_of_creation":"HotelTonight","reservation_created_date":"2019-08-01 06:25:05","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":"43.39","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3021533","reservation_id":"84148","confirmation_number":"PB12329343627","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.02,91.73,114.67","nightly_discount":"0.00,0.00,0.00","subtotal":"281.42","grand_total":"318.01","paid_amount":"0.00","room_type_id":"313","product_id":"1228","siteminder_id":"GAM-R1662112087","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":"91647","customer_id":"91647","source_of_creation":"Getaroom.com","reservation_created_date":"2019-09-15 18:43:09","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":"91.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021860","reservation_id":"84530","confirmation_number":"BP12573497633","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.86,48.86","nightly_discount":"0,0","subtotal":"97.72","grand_total":"110.42","paid_amount":"110.42","room_type_id":"293","product_id":"1124","siteminder_id":"GAM-R1672043527","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":"91908","customer_id":"91908","source_of_creation":"Getaroom.com","reservation_created_date":"2019-09-22 14:19:08","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.86","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[{"room_stay_id":"3021978","reservation_id":"81483","confirmation_number":"BP12567026140","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.1,62.1,62.1,62.1,62.1","nightly_discount":"0,0,0,0,0","subtotal":"310.50","grand_total":"350.87","paid_amount":"350.87","room_type_id":"304","product_id":"1221","siteminder_id":"ZOO-6659-1678-6797","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":"89423","customer_id":"89423","source_of_creation":"Travelzoo","reservation_created_date":"2019-07-26 17:11:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.1","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"}]}],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3002050","reservation_id":"81237","confirmation_number":"BP12521273972","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"77.60,77.60,77.60","nightly_discount":"0,0,0","subtotal":"232.80","grand_total":"303.74","paid_amount":"303.74","room_type_id":"299","product_id":"1134","siteminder_id":"ABB-HMAH2Y2QCM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"232.80","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89257","customer_id":"89257","source_of_creation":"Airbnb","reservation_created_date":"2019-07-23 00:06:05","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"32.54","commision_charges":"7.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3021692","reservation_id":"84498","confirmation_number":"BP12524591461","room_stay_from":"2019-09-22","room_stay_to":"2019-09-23","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"83.82","nightly_discount":"0","subtotal":"83.82","grand_total":"94.72","paid_amount":"0.00","room_type_id":"301","product_id":"1136","siteminder_id":"HWR-300991062","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91897","customer_id":"91897","source_of_creation":"Hotwire","reservation_created_date":"2019-09-21 22:52:11","service_canceled_date_time":"2019-09-23 14:09:09","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":-83.82,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[{"room_stay_id":"3021986","reservation_id":"84555","confirmation_number":"BP12511402935","room_stay_from":"2019-09-22","room_stay_to":"2019-09-23","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.87","nightly_discount":"0","subtotal":"51.87","grand_total":"58.61","paid_amount":"58.61","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-300995559","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":"91927","customer_id":"91927","source_of_creation":"Hotwire","reservation_created_date":"2019-09-23 01:44:06","service_canceled_date_time":"2019-09-23 01:54:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"6.74","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3021912","reservation_id":"84482","confirmation_number":"PB12336675317","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.32,68.32,68.32","nightly_discount":"0.00,0.00,0.00","subtotal":"204.96","grand_total":"231.61","paid_amount":"231.61","room_type_id":"289","product_id":"1109","siteminder_id":"AGO-281643350","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91890","customer_id":"91890","source_of_creation":"Agoda","reservation_created_date":"2019-09-21 18:51:10","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":"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":"3021939","reservation_id":"84485","confirmation_number":"BV12442618316","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.18,68.18,68.18,68.18,68.18","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"340.90","grand_total":"385.21","paid_amount":"385.21","room_type_id":"304","product_id":"1218","siteminder_id":"AGO-281650290","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":"49057","customer_id":"49057","source_of_creation":"Agoda","reservation_created_date":"2019-09-21 19:39:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022112","reservation_id":"84610","confirmation_number":"PB12372192841","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60,70.60","nightly_discount":"0,0","subtotal":"141.20","grand_total":"159.55","paid_amount":"159.55","room_type_id":"289","product_id":"1103","siteminder_id":"AGO-281930622","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":"88174","customer_id":"88174","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 17:51:10","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":"70.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022159","reservation_id":"84612","confirmation_number":"PB12375761859","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60","nightly_discount":"0","subtotal":"70.60","grand_total":"79.78","paid_amount":"79.78","room_type_id":"291","product_id":"1118","siteminder_id":"AGO-281930634","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":"91949","customer_id":"91949","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 17:51:23","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":"70.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022223","reservation_id":"84621","confirmation_number":"PB12317827454","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"75.34","nightly_discount":"0.00","subtotal":"75.34","grand_total":"85.13","paid_amount":"85.13","room_type_id":"292","product_id":"1120","siteminder_id":"AGO-281966342","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91956","customer_id":"91956","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 21:21:09","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":"75.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022253","reservation_id":"84625","confirmation_number":"PB12350858624","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.85","nightly_discount":"0.00","subtotal":"77.85","grand_total":"87.97","paid_amount":"87.97","room_type_id":"304","product_id":"1219","siteminder_id":"AGO-281990270","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":"91960","customer_id":"91960","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 23:39:10","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":"77.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[{"room_stay_id":"3022114","reservation_id":"84611","confirmation_number":"PB12338979454","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60,70.60","nightly_discount":"0,0","subtotal":"141.20","grand_total":"159.55","paid_amount":"159.55","room_type_id":"289","product_id":"1111","siteminder_id":"AGO-281930630","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":"91948","customer_id":"91948","source_of_creation":"Agoda","reservation_created_date":"2019-09-23 17:51:16","service_canceled_date_time":"2019-09-23 23:14:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"159.55","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"fe_taxable":[{"room_stay_id":"2986813","reservation_id":"78417","confirmation_number":"PB12361011111","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00","subtotal":"357.60","grand_total":"404.09","paid_amount":"404.09","room_type_id":"291","product_id":"1114","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":"87484","customer_id":"87484","source_of_creation":"FE","reservation_created_date":"2019-06-10 16:32:42","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":"119.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":"3005038","reservation_id":"81733","confirmation_number":"BV12419926335","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"110.88,110.88","nightly_discount":"0.00,0.00","subtotal":"221.76","grand_total":"250.59","paid_amount":"250.59","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":"89602","customer_id":"89602","source_of_creation":"FE","reservation_created_date":"2019-07-31 02:39:45","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":"3021906","reservation_id":"84306","confirmation_number":"PB12390885233","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,22.61,0.00","subtotal":"520.00","grand_total":"562.05","paid_amount":"562.05","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90237","customer_id":"90237","source_of_creation":"FE","reservation_created_date":"2019-09-18 14:46:15","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3022187","reservation_id":"83385","confirmation_number":"PB12321432779","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"82.56,82.56","nightly_discount":"0.00,0.00","subtotal":"165.12","grand_total":"186.59","paid_amount":"186.59","room_type_id":"286","product_id":"1086","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":"89974","customer_id":"89974","source_of_creation":"FE","reservation_created_date":"2019-08-29 13:48:49","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":"82.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3010233","reservation_id":"82597","confirmation_number":"PB12380421202","room_stay_from":"2019-09-21","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.80,160.80,160.80,160.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"659.20","grand_total":"744.89","paid_amount":"744.89","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":"59446","customer_id":"59446","source_of_creation":"PMS","reservation_created_date":"2019-08-14 00:18:17","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":"160.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":"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":"3021251","reservation_id":"57232","confirmation_number":"PB12317021359","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,35.33,0.00","subtotal":"798.00","grand_total":"861.82","paid_amount":"861.82","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70002","customer_id":"70002","source_of_creation":"PMS","reservation_created_date":"2018-09-28 12:21:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021411","reservation_id":"70858","confirmation_number":"PB12399611650","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,120.00,120.00,120.00,120.00,120.00","nightly_discount":"41.70,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"947.28","paid_amount":"947.28","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44540","customer_id":"44540","source_of_creation":"PMS","reservation_created_date":"2019-03-03 20:12:26","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021433","reservation_id":"57205","confirmation_number":"PB12352404720","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"805.00","grand_total":"909.65","paid_amount":"909.65","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":"23334","customer_id":"23334","source_of_creation":"PMS","reservation_created_date":"2018-09-27 19:22:16","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":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021536","reservation_id":"57222","confirmation_number":"PB12310106429","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"8.80,0.00,0.00,0.00,0.00,0.00,39.79,0.00","subtotal":"805.00","grand_total":"854.74","paid_amount":"854.74","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":"36512","customer_id":"36512","source_of_creation":"PMS","reservation_created_date":"2018-09-27 23:00:04","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":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021596","reservation_id":"80270","confirmation_number":"PB12369786647","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00,96.00,96.00,96.00,96.00,96.00,112.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"704.00","grand_total":"795.52","paid_amount":"795.52","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":"88617","customer_id":"88617","source_of_creation":"PMS","reservation_created_date":"2019-07-06 01:06:26","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":"3021777","reservation_id":"80272","confirmation_number":"PB12388926914","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"112.00,96.00,96.00,96.00,96.00,96.00,112.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,38.04,0.00","subtotal":"704.00","grand_total":"752.54","paid_amount":"752.54","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":"88617","customer_id":"88617","source_of_creation":"PMS","reservation_created_date":"2019-07-06 01:09:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3021930","reservation_id":"82982","confirmation_number":"PB12334539082","room_stay_from":"2019-09-23","room_stay_to":"2019-09-26","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":"291","product_id":"1115","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":"90450","customer_id":"90450","source_of_creation":"PMS","reservation_created_date":"2019-08-20 23:00:40","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3022027","reservation_id":"84595","confirmation_number":"PB12378673386","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"102.00","nightly_discount":"0.00","subtotal":"102.00","grand_total":"115.26","paid_amount":"115.26","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":"91935","customer_id":"91935","source_of_creation":"PMS","reservation_created_date":"2019-09-23 13:32:05","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":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022145","reservation_id":"76357","confirmation_number":"PB12375826026","room_stay_from":"2019-09-23","room_stay_to":"2019-09-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,201.00","nightly_discount":"0.00,0.00,0.00,32.42,0.00","subtotal":"804.00","grand_total":"871.88","paid_amount":"871.89","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85977","customer_id":"85977","source_of_creation":"PMS","reservation_created_date":"2019-05-13 16:46:14","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":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022213","reservation_id":"81031","confirmation_number":"BP12541933890","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.60,93.60,93.60,93.60,109.60,109.60,93.60,93.60,93.60,93.60,93.60,109.60,109.60,93.60,93.60,93.60,93.60,93.60,93.60,93.60,93.60","nightly_discount":"86.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2029.60","grand_total":"2195.37","paid_amount":"2195.37","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":"89141","customer_id":"89141","source_of_creation":"PMS","reservation_created_date":"2019-07-19 19:58:46","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":"","currentDayPrice":"93.60","currentDayDiscount":"86.80","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022219","reservation_id":"57926","confirmation_number":"BP12530019332","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"99.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2079.00","grand_total":"2237.40","paid_amount":"2237.40","room_type_id":"296","product_id":"1131","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58813","customer_id":"58813","source_of_creation":"PMS","reservation_created_date":"2018-10-09 15:24:13","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"99.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022396","reservation_id":"84663","confirmation_number":"PB12379580601","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60,70.60","nightly_discount":"0.00,0.00","subtotal":"141.20","grand_total":"159.55","paid_amount":"159.55","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88174","customer_id":"88174","source_of_creation":"PMS","reservation_created_date":"2019-09-24 21:48:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.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":"3024869","reservation_id":"80196","confirmation_number":"PB12332838153","room_stay_from":"2019-09-23","room_stay_to":"2019-10-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.80,148.80,148.80,148.80,164.80,164.80,148.80,148.80,148.80,148.80,148.80,164.80,164.80,148.80,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2236.20","grand_total":"2526.90","paid_amount":"2526.90","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":"48600","customer_id":"48600","source_of_creation":"PMS","reservation_created_date":"2019-07-04 22:48:30","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":"3026140","reservation_id":"82151","confirmation_number":"PB12314254400","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00","nightly_discount":"0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89896","customer_id":"89896","source_of_creation":"PMS","reservation_created_date":"2019-08-06 20:44:04","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028618","reservation_id":"84256","confirmation_number":"PB12327025728","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91739","customer_id":"91739","source_of_creation":"PMS","reservation_created_date":"2019-09-17 17:04:39","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":"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":"3028675","reservation_id":"81834","confirmation_number":"PB12329074584","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","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":"289","product_id":"1097","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":"89676","customer_id":"89676","source_of_creation":"PMS","reservation_created_date":"2019-08-01 17:54:40","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","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":"2996093","reservation_id":"74909","confirmation_number":"PB12311097502","room_stay_from":"2019-09-20","room_stay_to":"2019-09-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.80,176.80,160.80","nightly_discount":"0.00,0.00,0.00","subtotal":"514.40","grand_total":"581.27","paid_amount":"581.27","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58691","customer_id":"58691","source_of_creation":"PMS","reservation_created_date":"2019-04-18 12:52:41","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":"","changedComment":"Nightly price or discount changed","deltaChange":"170.40","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3012359","reservation_id":"82981","confirmation_number":"PB12351896731","room_stay_from":"2019-09-23","room_stay_to":"2019-09-26","room_stay_status":"Active","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":"76.84","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90449","customer_id":"90449","source_of_creation":"PMS","reservation_created_date":"2019-08-20 22:45:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":104,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3021608","reservation_id":"80272","confirmation_number":"PB12284245844","room_confirmation_number":"PB12388926914","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"88617","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-21 18:53:11","reservation_modified_date_time":"2019-09-21 18:53:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88617","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022028","reservation_id":"84595","confirmation_number":"PB12265939531","room_confirmation_number":"PB12378673386","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"91935","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-23 13:32:05","reservation_modified_date_time":"2019-09-23 13:32:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91935","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":"3021693","reservation_id":"84498","confirmation_number":"BP12299190252","room_confirmation_number":"BP12524591461","room_stay_from":"2019-09-22","room_stay_to":"2019-09-23","room_stay_status":"Canceled","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-22 00:35:02","reservation_modified_date_time":"2019-09-22 00:35:02","customer_id":"91897","parentCustTravId":"91897","customer_traveller_id":"91897","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-23 14:09:09","canceled_nights_data":"","product_attribute_values":"extra_person#&#10","deltaChange":-10,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3012360","reservation_id":"82981","confirmation_number":"PB12292734281","room_confirmation_number":"PB12351896731","room_stay_from":"2019-09-23","room_stay_to":"2019-09-26","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-20 22:45:05","reservation_modified_date_time":"2019-08-20 22:45:05","customer_id":"90449","parentCustTravId":"90449","customer_traveller_id":"90449","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#12","currentDayPrice":12,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986814","reservation_id":"78417","confirmation_number":"PB12270451568","room_confirmation_number":"PB12361011111","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","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":"87484","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-10 16:32:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87484","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":"3002051","reservation_id":"81237","confirmation_number":"BP12250492060","room_confirmation_number":"BP12521273972","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","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":"89257","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-23 00:06:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89257","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3004753","reservation_id":"81700","confirmation_number":"PB12222283784","room_confirmation_number":"PB12340192578","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","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":"89571","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-30 12:37:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89571","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":"3005039","reservation_id":"81733","confirmation_number":"BV12297199009","room_confirmation_number":"BV12419926335","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"89602","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-31 02:39:45","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89602","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":"3005329","reservation_id":"81792","confirmation_number":"PB12298485035","room_confirmation_number":"PB12311733722","room_stay_from":"2019-09-20","room_stay_to":"2019-09-24","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":"89648","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-01 00:27:11","reservation_modified_date_time":"2019-08-01 00:27:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89648","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":"3007712","reservation_id":"82139","confirmation_number":"BP12254267182","room_confirmation_number":"BP12594684570","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"89885","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-06 18:32:08","reservation_modified_date_time":"2019-08-06 18:32:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89885","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":"3010234","reservation_id":"82597","confirmation_number":"PB12267095179","room_confirmation_number":"PB12380421202","room_stay_from":"2019-09-21","room_stay_to":"2019-09-25","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":"59446","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-14 00:18:17","reservation_modified_date_time":"2019-08-14 00:18:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59446","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":"3012752","reservation_id":"83029","confirmation_number":"PB12248947952","room_confirmation_number":"PB12318388398","room_stay_from":"2019-09-22","room_stay_to":"2019-09-29","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"90486","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-22 01:17:08","reservation_modified_date_time":"2019-08-22 01:17:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90486","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":"3013670","reservation_id":"82739","confirmation_number":"PB12257915353","room_confirmation_number":"PB12389315849","room_stay_from":"2019-09-21","room_stay_to":"2019-09-24","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":"90287","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-16 14:47:10","reservation_modified_date_time":"2019-08-16 14:47:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90287","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":"3014638","reservation_id":"83350","confirmation_number":"PB12253960548","room_confirmation_number":"PB12367134751","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"90715","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-28 18:21:15","reservation_modified_date_time":"2019-08-28 18:21:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90715","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":"3020727","reservation_id":"84325","confirmation_number":"BP12229027118","room_confirmation_number":"BP12543179698","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","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":"91797","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 19:32:10","reservation_modified_date_time":"2019-09-18 19:32:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91797","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":"3020763","reservation_id":"84332","confirmation_number":"PB12275205755","room_confirmation_number":"PB12324192589","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91803","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 21:57:07","reservation_modified_date_time":"2019-09-18 21:57:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91803","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":"3021252","reservation_id":"57232","confirmation_number":"PB12337445687","room_confirmation_number":"PB12317021359","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"70002","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-09-28 12:23:59","reservation_modified_date_time":"2019-09-20 20:13:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70002","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":"3021412","reservation_id":"70858","confirmation_number":"PB12242814831","room_confirmation_number":"PB12399611650","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","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":"44540","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-03 20:12:26","reservation_modified_date_time":"2019-09-21 02:48:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44540","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":"3021434","reservation_id":"57205","confirmation_number":"PB12354066679","room_confirmation_number":"PB12352404720","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23334","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-09-27 19:22:22","reservation_modified_date_time":"2019-09-21 02:53:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23334","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":"3021534","reservation_id":"84148","confirmation_number":"PB12246622874","room_confirmation_number":"PB12329343627","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","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":"91647","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-15 18:43:09","reservation_modified_date_time":"2019-09-21 15:14:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91647","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":"3021537","reservation_id":"57222","confirmation_number":"PBR12216614344","room_confirmation_number":"PB12310106429","room_stay_from":"2019-09-20","room_stay_to":"2019-09-27","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":"36512","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-09-21 15:49:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36512","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":"3021597","reservation_id":"80270","confirmation_number":"PB12281708148","room_confirmation_number":"PB12369786647","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","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":"88617","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-06 01:06:26","reservation_modified_date_time":"2019-09-21 18:49:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88617","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":"3021778","reservation_id":"80272","confirmation_number":"PB12269193891","room_confirmation_number":"PB12388926914","room_stay_from":"2019-09-21","room_stay_to":"2019-09-28","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":"88617","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-06 01:09:05","reservation_modified_date_time":"2019-09-22 02:11:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88617","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":"3021861","reservation_id":"84530","confirmation_number":"BP12216512877","room_confirmation_number":"BP12573497633","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"91908","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-22 14:19:08","reservation_modified_date_time":"2019-09-22 14:19:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91908","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":"3021892","reservation_id":"81809","confirmation_number":"PB12226574470","room_confirmation_number":"PB12344051789","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","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":"89654","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-01 06:25:05","reservation_modified_date_time":"2019-09-22 17:32:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89654","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":"3021907","reservation_id":"84306","confirmation_number":"PB12292524337","room_confirmation_number":"PB12390885233","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","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":"90237","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 14:46:15","reservation_modified_date_time":"2019-09-22 18:38:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90237","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":"3021914","reservation_id":"84482","confirmation_number":"PB12261869534","room_confirmation_number":"PB12336675317","room_stay_from":"2019-09-22","room_stay_to":"2019-09-25","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":"91890","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-21 18:51:10","reservation_modified_date_time":"2019-09-22 18:46:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91890","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":"3021922","reservation_id":"84285","confirmation_number":"PB12271404593","room_confirmation_number":"PB12332585816","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","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":"91764","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-18 00:52:09","reservation_modified_date_time":"2019-09-18 00:52:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91764","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":"3021931","reservation_id":"82982","confirmation_number":"PB12269411632","room_confirmation_number":"PB12334539082","room_stay_from":"2019-09-23","room_stay_to":"2019-09-26","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":"90450","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-20 23:00:40","reservation_modified_date_time":"2019-08-20 23:00:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90450","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":"3021933","reservation_id":"84538","confirmation_number":"PB12214483534","room_confirmation_number":"PB12395781536","room_stay_from":"2019-09-22","room_stay_to":"2019-09-24","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":"91913","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-22 18:07:07","reservation_modified_date_time":"2019-09-22 18:07:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91913","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":"3021940","reservation_id":"84485","confirmation_number":"BV12281247629","room_confirmation_number":"BV12442618316","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91893","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-21 19:39:10","reservation_modified_date_time":"2019-09-22 21:01:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"49057","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":"3021979","reservation_id":"81483","confirmation_number":"BP12210631270","room_confirmation_number":"BP12567026140","room_stay_from":"2019-09-22","room_stay_to":"2019-09-27","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":"89423","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-26 17:11:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89423","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":"3022029","reservation_id":"84595","confirmation_number":"PB12263998303","room_confirmation_number":"PB12378673386","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91935","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-23 13:32:05","reservation_modified_date_time":"2019-09-23 13:32:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91935","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":"3022113","reservation_id":"84610","confirmation_number":"PB12222809096","room_confirmation_number":"PB12372192841","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"88174","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 17:51:10","reservation_modified_date_time":"2019-09-23 17:51:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88174","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":"3022146","reservation_id":"76357","confirmation_number":"PB12249803042","room_confirmation_number":"PB12375826026","room_stay_from":"2019-09-23","room_stay_to":"2019-09-27","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":"85977","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-13 16:46:14","reservation_modified_date_time":"2019-09-23 19:33:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85977","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":"3022160","reservation_id":"84612","confirmation_number":"PB12268749554","room_confirmation_number":"PB12375761859","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91949","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 17:51:23","reservation_modified_date_time":"2019-09-23 17:51:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91949","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":"3022188","reservation_id":"83385","confirmation_number":"PB12295846343","room_confirmation_number":"PB12321432779","room_stay_from":"2019-09-23","room_stay_to":"2019-09-25","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":"89974","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 13:48:49","reservation_modified_date_time":"2019-08-29 13:48:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89974","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":"3022196","reservation_id":"84620","confirmation_number":"PB12279557605","room_confirmation_number":"PB12378676250","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91955","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 21:08:10","reservation_modified_date_time":"2019-09-23 21:08:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91955","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":"3022214","reservation_id":"81031","confirmation_number":"BP12246988669","room_confirmation_number":"BP12541933890","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89141","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-19 19:58:46","reservation_modified_date_time":"2019-09-23 22:48:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89141","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":"3022220","reservation_id":"57926","confirmation_number":"BP12547187980","room_confirmation_number":"BP12530019332","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"58813","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-10-09 15:24:13","reservation_modified_date_time":"2019-09-23 23:00:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58813","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":"3022225","reservation_id":"84621","confirmation_number":"PB12249982567","room_confirmation_number":"PB12317827454","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91956","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 21:21:09","reservation_modified_date_time":"2019-09-23 23:08:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91956","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":"3022254","reservation_id":"84625","confirmation_number":"PB12251311793","room_confirmation_number":"PB12350858624","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91960","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-23 23:39:10","reservation_modified_date_time":"2019-09-24 01:16:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91960","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":"3024870","reservation_id":"80196","confirmation_number":"PB12223524481","room_confirmation_number":"PB12332838153","room_stay_from":"2019-09-23","room_stay_to":"2019-10-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"48600","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-04 22:48:30","reservation_modified_date_time":"2019-10-03 13:25:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48600","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":"3028619","reservation_id":"84256","confirmation_number":"PB12255048723","room_confirmation_number":"PB12327025728","room_stay_from":"2019-09-23","room_stay_to":"2019-09-24","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":"91739","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-17 17:04:39","reservation_modified_date_time":"2019-10-15 15:00:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91739","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":"3028676","reservation_id":"81834","confirmation_number":"PB12277301453","room_confirmation_number":"PB12329074584","room_stay_from":"2019-09-22","room_stay_to":"2019-09-26","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":"89676","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-01 17:54:40","reservation_modified_date_time":"2019-10-15 16:47:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89676","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":"3021694","reservation_id":"84498","confirmation_number":"BP12262679402","room_confirmation_number":"BP12524591461","room_stay_from":"2019-09-22","room_stay_to":"2019-09-23","room_stay_status":"Canceled","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-21 22:52:11","reservation_modified_date_time":"2019-09-21 22:52:11","customer_id":"91897","parentCustTravId":"91897","customer_traveller_id":"91897","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-23 14:09:09","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3022081","reservation_id":"84607","confirmation_number":"BP12272132372","room_confirmation_number":"BP12520615229","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-23 16:00:50","reservation_modified_date_time":"2019-09-23 16:00:50","customer_id":"67859","parentCustTravId":"67859","customer_traveller_id":"67859","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":"3022102","reservation_id":"81809","confirmation_number":"PB12288989344","room_confirmation_number":"PB12344051789","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.26","grand_total":"3.49","paid_amount":"3.49","product_id":"1206","service_quantity":"1","product_name":"Toothpaste","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 16:58:04","reservation_modified_date_time":"2019-09-23 16:58:04","customer_id":"89654","parentCustTravId":"89654","customer_traveller_id":"89654","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":"3.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3022111","reservation_id":"83350","confirmation_number":"PB12228336341","room_confirmation_number":"PB12367134751","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 17:31:38","reservation_modified_date_time":"2019-09-23 17:31:38","customer_id":"90715","parentCustTravId":"90715","customer_traveller_id":"90715","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":"3022189","reservation_id":"83385","confirmation_number":"PB12273387423","room_confirmation_number":"PB12321432779","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":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 20:51:58","reservation_modified_date_time":"2019-09-23 20:51:58","customer_id":"89974","parentCustTravId":"89974","customer_traveller_id":"89974","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":"3022190","reservation_id":"83385","confirmation_number":"PB12237801578","room_confirmation_number":"PB12321432779","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":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 20:52:14","reservation_modified_date_time":"2019-09-23 20:52:14","customer_id":"89974","parentCustTravId":"89974","customer_traveller_id":"89974","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":"3022032","reservation_id":"84597","confirmation_number":"PB12256908086","room_confirmation_number":"PB12387827607","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-23 13:48:08","reservation_modified_date_time":"2019-09-23 13:48: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":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3014536","reservation_id":"83333","confirmation_number":"PB12269761524","room_confirmation_number":"PB12376448583","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-28 12:42:55","reservation_modified_date_time":"2019-08-28 12:42:55","customer_id":"90701","parentCustTravId":"90701","customer_traveller_id":"90701","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-24 01:54:21","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3021677","reservation_id":"84498","confirmation_number":"BP12230973691","room_confirmation_number":"BP12524591461","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"100.00","grand_total":"113.00","paid_amount":"0.00","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-21 23:49:50","reservation_modified_date_time":"2019-09-21 23:49:50","customer_id":"91897","parentCustTravId":"91897","customer_traveller_id":"91897","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-23 14:09:09","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-100,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":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":[]}}