{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-06-09","total_rooms_exist":66,"departureCount":33,"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":"2948298","reservation_id":"71786","confirmation_number":"PB12381625692","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.60,222.60,192.60,192.60","nightly_discount":"0,0,0,0","subtotal":"830.40","grand_total":"938.35","paid_amount":"938.35","room_type_id":"289","product_id":"1096","siteminder_id":"BDC-1153921792","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":"83147","customer_id":"83147","source_of_creation":"Booking.com","reservation_created_date":"2019-03-12 21:09:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"243.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"192.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":"2979009","reservation_id":"76934","confirmation_number":"PB12329660198","room_stay_from":"2019-06-09","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.85,181.85","nightly_discount":"0,0","subtotal":"363.70","grand_total":"410.98","paid_amount":"410.98","room_type_id":"286","product_id":"1086","siteminder_id":"BDC-2389477332","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":"86422","customer_id":"86422","source_of_creation":"Booking.com","reservation_created_date":"2019-05-20 16:22:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"54.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"181.85","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":"2985529","reservation_id":"71786","confirmation_number":"PB12366644934","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"213.60,213.60,183.60,183.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"794.40","grand_total":"897.67","paid_amount":"897.67","room_type_id":"289","product_id":"1095","siteminder_id":"BDC-1153921792","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":"83147","customer_id":"83147","source_of_creation":"Booking.com","reservation_created_date":"2019-03-12 21:09:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"243.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2920824","reservation_id":"67270","confirmation_number":"PB12361036361","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.20,177.60,177.60,139.20","nightly_discount":"0,0,0,0","subtotal":"633.60","grand_total":"715.97","paid_amount":"715.97","room_type_id":"289","product_id":"1106","siteminder_id":"EXP-1182580156","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":"80559","customer_id":"80559","source_of_creation":"Expedia","reservation_created_date":"2019-01-19 16:40:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986417","reservation_id":"78237","confirmation_number":"BP12599279631","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.00","nightly_discount":"0.00","subtotal":"88.00","grand_total":"99.44","paid_amount":"99.44","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1273444172","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":"87361","customer_id":"87361","source_of_creation":"Expedia","reservation_created_date":"2019-06-07 23:28:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986533","reservation_id":"78347","confirmation_number":"BV12416959007","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.72","nightly_discount":"0","subtotal":"81.72","grand_total":"92.34","paid_amount":"92.34","room_type_id":"303","product_id":"1139","siteminder_id":"EXP-1274460737","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":"87430","customer_id":"87430","source_of_creation":"Expedia","reservation_created_date":"2019-06-09 20:03:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"81.72","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":"2974536","reservation_id":"76050","confirmation_number":"PB12366537272","room_stay_from":"2019-06-08","room_stay_to":"2019-06-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.22,73.22,73.22,73.22","nightly_discount":"0,0,0,0","subtotal":"292.88","grand_total":"330.95","paid_amount":"330.95","room_type_id":"291","product_id":"1115","siteminder_id":"HTN-84079303-MEMTY4","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":"85768","customer_id":"85768","source_of_creation":"HotelTonight","reservation_created_date":"2019-05-09 00:42:10","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":"73.22","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":"2986518","reservation_id":"78333","confirmation_number":"BV12493338987","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"54.53","nightly_discount":"0.00","subtotal":"54.53","grand_total":"61.62","paid_amount":"61.62","room_type_id":"289","product_id":"1112","siteminder_id":"HTN-87392710-JWJWGA","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":"87419","customer_id":"87419","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-09 17:32:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"54.53","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986543","reservation_id":"78350","confirmation_number":"PB12319075885","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.51","nightly_discount":"0","subtotal":"81.51","grand_total":"92.11","paid_amount":"92.11","room_type_id":"289","product_id":"1104","siteminder_id":"HTN-87409200-LX9DCZ","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":"87433","customer_id":"87433","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-09 20:32:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"81.51","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2986436","reservation_id":"78330","confirmation_number":"BP12547078574","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.93","nightly_discount":"0","subtotal":"69.93","grand_total":"79.03","paid_amount":"79.03","room_type_id":"298","product_id":"1133","siteminder_id":"GAM-R1531287164","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":"87417","customer_id":"87417","source_of_creation":"Getaroom.com","reservation_created_date":"2019-06-09 17:21:06","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":"69.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2984231","reservation_id":"75224","confirmation_number":"PB12390665476","room_stay_from":"2019-06-03","room_stay_to":"2019-06-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"169.00,169.00,169.00,169.00,169.00,169.00,169.00,178.00,178.00","nightly_discount":"91.35,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1539.00","grand_total":"1635.85","paid_amount":"1635.85","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":"47007","customer_id":"47007","source_of_creation":"FE","reservation_created_date":"2019-04-24 03:45:51","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":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986094","reservation_id":"76196","confirmation_number":"PB12351348127","room_stay_from":"2019-06-08","room_stay_to":"2019-06-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.90,141.84,141.84,141.84,141.84,141.84,172.90,172.90,141.84","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,73.87,0.00","subtotal":"1369.74","grand_total":"1464.33","paid_amount":"1464.33","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":"57906","customer_id":"57906","source_of_creation":"FE","reservation_created_date":"2019-05-10 17:59:52","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":"141.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"124248","reservation_id":"48973","confirmation_number":"PB12377478985","room_stay_from":"2019-06-04","room_stay_to":"2019-06-25","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,109.00,109.00,109.00,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,0.00,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":"2289.00","grand_total":"2586.57","paid_amount":"2586.57","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":"71132","customer_id":"71132","source_of_creation":"PMS","reservation_created_date":"2018-06-13 16:11:13","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 104","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":"124250","reservation_id":"48972","confirmation_number":"PB12360803854","room_stay_from":"2019-06-04","room_stay_to":"2019-06-25","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,109.00,109.00,109.00,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,0.00,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":"2289.00","grand_total":"2586.57","paid_amount":"2586.57","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":"71131","customer_id":"71131","source_of_creation":"PMS","reservation_created_date":"2018-06-13 15:57:50","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 106","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":"2880839","reservation_id":"59146","confirmation_number":"PB12352409290","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.00,225.00,225.00,175.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"800.00","grand_total":"904.00","paid_amount":"904.00","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76392","customer_id":"76392","source_of_creation":"PMS","reservation_created_date":"2018-10-28 12:27:00","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":"175.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961269","reservation_id":"73950","confirmation_number":"PB12343233801","room_stay_from":"2019-06-08","room_stay_to":"2019-06-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,85.50,85.50,85.50,85.50,85.50,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"647.50","grand_total":"731.68","paid_amount":"731.68","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84555","customer_id":"84555","source_of_creation":"PMS","reservation_created_date":"2019-04-03 18:03:55","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961271","reservation_id":"73950","confirmation_number":"PB12334946299","room_stay_from":"2019-06-08","room_stay_to":"2019-06-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,85.50,85.50,85.50,85.50,85.50,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"647.50","grand_total":"731.68","paid_amount":"731.68","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84555","customer_id":"84555","source_of_creation":"PMS","reservation_created_date":"2019-04-03 18:03:55","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":"85.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962471","reservation_id":"74131","confirmation_number":"PB12314895758","room_stay_from":"2019-06-09","room_stay_to":"2019-06-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.00,197.00,197.00,197.00,197.00,247.00,247.00,197.00,197.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1873.00","grand_total":"2116.49","paid_amount":"2116.49","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84672","customer_id":"84672","source_of_creation":"PMS","reservation_created_date":"2019-04-05 22:00:40","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"197.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2968882","reservation_id":"75160","confirmation_number":"PB12365188705","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"283.00,233.00,233.00","nightly_discount":"0.00,0.00,0.00","subtotal":"749.00","grand_total":"846.37","paid_amount":"846.37","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85253","customer_id":"85253","source_of_creation":"PMS","reservation_created_date":"2019-04-23 00:27:51","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"233.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2968884","reservation_id":"75160","confirmation_number":"PB12365228839","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"283.00,233.00,233.00","nightly_discount":"0.00,0.00,0.00","subtotal":"749.00","grand_total":"846.37","paid_amount":"846.37","room_type_id":"288","product_id":"1092","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85253","customer_id":"85253","source_of_creation":"PMS","reservation_created_date":"2019-04-23 00:27:52","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"233.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2976226","reservation_id":"76374","confirmation_number":"BV12443214292","room_stay_from":"2019-06-09","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.24,138.24,138.24,138.24,138.24,169.40,169.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1030.00","grand_total":"1163.90","paid_amount":"1163.90","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85989","customer_id":"85989","source_of_creation":"PMS","reservation_created_date":"2019-05-13 20:37:10","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2980918","reservation_id":"77317","confirmation_number":"BV12466590545","room_stay_from":"2019-06-08","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.50,133.20","nightly_discount":"0.00,0.00","subtotal":"297.70","grand_total":"336.40","paid_amount":"336.40","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":"86719","customer_id":"86719","source_of_creation":"PMS","reservation_created_date":"2019-05-25 18:03:55","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":"133.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":"2985012","reservation_id":"78128","confirmation_number":"BP12571082165","room_stay_from":"2019-06-09","room_stay_to":"2019-06-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","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","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":"87291","customer_id":"87291","source_of_creation":"PMS","reservation_created_date":"2019-06-06 18:36:43","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2985017","reservation_id":"67279","confirmation_number":"PB12376265242","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.40,242.40,242.40,242.40","nightly_discount":"0.00,0.00,29.43,0.00","subtotal":"929.60","grand_total":"1017.19","paid_amount":"1017.19","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":"80332","customer_id":"80332","source_of_creation":"PMS","reservation_created_date":"2019-01-19 18:02:27","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":"242.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985099","reservation_id":"74991","confirmation_number":"PB12394085452","room_stay_from":"2019-06-06","room_stay_to":"2019-06-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.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,92.94,0.00","subtotal":"2028.00","grand_total":"2186.61","paid_amount":"2186.61","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":"72285","customer_id":"72285","source_of_creation":"PMS","reservation_created_date":"2019-04-19 20:35:42","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":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985425","reservation_id":"30714","confirmation_number":"PB973603549","room_stay_from":"2019-06-07","room_stay_to":"2019-06-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,188.00,188.00,188.00,225.07","nightly_discount":"20.82,20.82,20.82,20.82,20.82","subtotal":"1014.07","grand_total":"1028.27","paid_amount":"1028.27","room_type_id":"289","product_id":"1100","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":"70629","customer_id":"70629","source_of_creation":"PMS","reservation_created_date":"2018-05-06 17:06:15","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.00","currentDayDiscount":"20.82","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985467","reservation_id":"30714","confirmation_number":"PB935140457","room_stay_from":"2019-06-07","room_stay_to":"2019-06-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,188.00,188.00,188.00,205.16","nightly_discount":"20.82,20.82,20.82,20.82,20.83,0.00","subtotal":"994.16","grand_total":"1005.75","paid_amount":"1005.76","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":"70629","customer_id":"70629","source_of_creation":"PMS","reservation_created_date":"2018-05-06 17:06:18","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.00","currentDayDiscount":"20.82","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985619","reservation_id":"49341","confirmation_number":"PB12349205705","room_stay_from":"2019-06-07","room_stay_to":"2019-06-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00","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,108.26,0.00","subtotal":"2055.00","grand_total":"2199.81","paid_amount":"2199.81","room_type_id":"292","product_id":"1120","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23420","customer_id":"23420","source_of_creation":"PMS","reservation_created_date":"2018-06-18 20:11:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985753","reservation_id":"50129","confirmation_number":"PB12338494939","room_stay_from":"2019-06-07","room_stay_to":"2019-06-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00,225.00,225.00,225.00,225.00,225.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,121.10,0.00","subtotal":"2250.00","grand_total":"2405.65","paid_amount":"2405.65","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":"51959","customer_id":"51959","source_of_creation":"PMS","reservation_created_date":"2018-07-01 15:06:55","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985828","reservation_id":"49163","confirmation_number":"PB12327682836","room_stay_from":"2019-06-07","room_stay_to":"2019-06-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.45,135.45,135.45,135.45,135.45,135.45,135.45,135.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,54.35,0.00","subtotal":"1083.60","grand_total":"1163.06","paid_amount":"1163.06","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":"24155","customer_id":"24155","source_of_creation":"PMS","reservation_created_date":"2018-06-16 00:20:24","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.45","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985961","reservation_id":"77580","confirmation_number":"BV12468791296","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"155.40,100.31,100.31","nightly_discount":"0.00,16.33,0.00","subtotal":"356.02","grand_total":"383.85","paid_amount":"383.85","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86888","customer_id":"86888","source_of_creation":"PMS","reservation_created_date":"2019-05-29 21:26:12","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.31","currentDayDiscount":"16.33","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986034","reservation_id":"76450","confirmation_number":"PB12335712208","room_stay_from":"2019-06-07","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.48,116.48,91.01","nightly_discount":"0.00,0.00,0.00","subtotal":"323.97","grand_total":"366.09","paid_amount":"311.85","room_type_id":"290","product_id":"1113","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86062","customer_id":"86062","source_of_creation":"PMS","reservation_created_date":"2019-05-14 23:42:40","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.01","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986057","reservation_id":"65991","confirmation_number":"BP12554688617","room_stay_from":"2019-06-08","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.40,146.97,146.97,146.97,146.97,146.97,211.40,211.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,147.00,0.00","subtotal":"1369.05","grand_total":"1380.91","paid_amount":"1380.91","room_type_id":"297","product_id":"1132","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79675","customer_id":"79675","source_of_creation":"PMS","reservation_created_date":"2019-01-08 21:02:13","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"146.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986065","reservation_id":"49287","confirmation_number":"PB12385603873","room_stay_from":"2019-06-08","room_stay_to":"2019-06-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"132.00,132.00,132.00,132.00,132.00,132.00,132.00,132.00,132.00,132.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,74.37,0.00","subtotal":"1320.00","grand_total":"1407.56","paid_amount":"1407.56","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":"24154","customer_id":"24154","source_of_creation":"PMS","reservation_created_date":"2018-06-17 21:40:57","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":"132.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986221","reservation_id":"74802","confirmation_number":"BP12541956422","room_stay_from":"2019-06-08","room_stay_to":"2019-06-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.00,135.00,135.00,135.00,135.00","nightly_discount":"0.00,0.00,0.00,0.00,33.63,0.00","subtotal":"729.00","grand_total":"785.77","paid_amount":"785.77","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79410","customer_id":"79410","source_of_creation":"PMS","reservation_created_date":"2019-04-16 00:18:05","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986245","reservation_id":"67279","confirmation_number":"PB12378515570","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.40,242.40,242.40,242.40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"929.60","grand_total":"1050.45","paid_amount":"1050.45","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80332","customer_id":"80332","source_of_creation":"PMS","reservation_created_date":"2019-01-19 18:02:27","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"242.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986249","reservation_id":"77964","confirmation_number":"PB12378530650","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87156","customer_id":"87156","source_of_creation":"PMS","reservation_created_date":"2019-06-04 18:17:27","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":"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":"2986344","reservation_id":"49279","confirmation_number":"PB12378826051","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,76.78,0.00","subtotal":"1251.00","grand_total":"1326.87","paid_amount":"1326.87","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":"71291","customer_id":"71291","source_of_creation":"PMS","reservation_created_date":"2018-06-17 20:34:20","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986346","reservation_id":"78185","confirmation_number":"BP12552165585","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00","nightly_discount":"0.00","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87325","customer_id":"87325","source_of_creation":"PMS","reservation_created_date":"2019-06-09 14:15:11","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986457","reservation_id":"78336","confirmation_number":"PB12317143326","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"139.00","nightly_discount":"0.00","subtotal":"139.00","grand_total":"157.07","paid_amount":"157.07","room_type_id":"289","product_id":"1103","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87421","customer_id":"87421","source_of_creation":"PMS","reservation_created_date":"2019-06-09 17:57:21","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":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986480","reservation_id":"73195","confirmation_number":"PB12374539344","room_stay_from":"2019-06-09","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"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":"84101","customer_id":"84101","source_of_creation":"PMS","reservation_created_date":"2019-03-26 13:43:19","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":"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":"2986606","reservation_id":"76676","confirmation_number":"BP12523489838","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"139.30,139.30,107.28,69.00","nightly_discount":"0.00,0.00,17.65,3.51,0.00","subtotal":"454.88","grand_total":"490.10","paid_amount":"490.10","room_type_id":"293","product_id":"1124","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":"50311","customer_id":"50311","source_of_creation":"PMS","reservation_created_date":"2019-05-17 14:33:07","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":"107.28","currentDayDiscount":"17.65","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986613","reservation_id":"78359","confirmation_number":"PB12335695811","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00","nightly_discount":"0.00","subtotal":"139.00","grand_total":"157.07","paid_amount":"157.07","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":"87439","customer_id":"87439","source_of_creation":"PMS","reservation_created_date":"2019-06-09 22:07:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986702","reservation_id":"78387","confirmation_number":"PB12369997817","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00","nightly_discount":"0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","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":"87458","customer_id":"87458","source_of_creation":"PMS","reservation_created_date":"2019-06-10 02:31:51","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":"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":"2987810","reservation_id":"49098","confirmation_number":"PB12370255816","room_stay_from":"2019-06-03","room_stay_to":"2019-06-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1430.00","grand_total":"1615.90","paid_amount":"1615.90","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28346","customer_id":"28346","source_of_creation":"PMS","reservation_created_date":"2018-06-15 13:06:56","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2987984","reservation_id":"49248","confirmation_number":"PB12375249256","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.00,136.00,136.00,136.00,136.00,136.00,136.00,136.00,136.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,61.00","subtotal":"1224.00","grand_total":"1314.19","paid_amount":"1344.70","room_type_id":"285","product_id":"1083","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":"71278","customer_id":"71278","source_of_creation":"PMS","reservation_created_date":"2018-06-17 16:01:56","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":"136.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2988613","reservation_id":"67751","confirmation_number":"PB12380644057","room_stay_from":"2019-06-05","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1441.00","grand_total":"1628.33","paid_amount":"1628.33","room_type_id":"289","product_id":"1109","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":"26113","customer_id":"26113","source_of_creation":"PMS","reservation_created_date":"2019-01-25 00:32:35","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":"131.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2988778","reservation_id":"49225","confirmation_number":"PB12362772148","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.00,136.00,136.00,136.00,136.00,136.00,136.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,68.30,0.00","subtotal":"1220.00","grand_total":"1301.42","paid_amount":"1301.42","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":"62154","customer_id":"62154","source_of_creation":"PMS","reservation_created_date":"2018-06-16 22:41:40","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2970264","reservation_id":"75224","confirmation_number":"PB12256440555","room_confirmation_number":"PB12390665476","room_stay_from":"2019-06-03","room_stay_to":"2019-06-12","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"47007","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-04-26 21:18:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47007","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2982435","reservation_id":"77580","confirmation_number":"BV12219527275","room_confirmation_number":"BV12468791296","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"86888","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-05-29 21:26:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86888","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985531","reservation_id":"71786","confirmation_number":"PB12244088074","room_confirmation_number":"PB12366644934","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0,0,0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"83147","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-07 19:23:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83147","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":"2986459","reservation_id":"78336","confirmation_number":"PB12256461011","room_confirmation_number":"PB12317143326","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"10.00","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"87421","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-09 17:57:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87421","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986605","reservation_id":"76676","confirmation_number":"BP12266543247","room_confirmation_number":"BP12523489838","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"50311","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-06-09 21:26:26","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50311","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898886","reservation_id":"59146","confirmation_number":"PBR12273574624","room_confirmation_number":"PB12352409290","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"76392","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76392","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2920825","reservation_id":"67270","confirmation_number":"PB12291978310","room_confirmation_number":"PB12361036361","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"80559","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-19 16:40:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80559","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":"2927922","reservation_id":"48973","confirmation_number":"PB12378722258","room_confirmation_number":"PB12377478985","room_stay_from":"2019-06-04","room_stay_to":"2019-06-25","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"71132","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-06-15 07:59:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71132","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2927923","reservation_id":"48972","confirmation_number":"PB12339615634","room_confirmation_number":"PB12360803854","room_stay_from":"2019-06-04","room_stay_to":"2019-06-25","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"71131","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-06-15 08:02:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71131","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2948299","reservation_id":"71786","confirmation_number":"PB12257871279","room_confirmation_number":"PB12381625692","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83147","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-03-12 21:09:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83147","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":"2961270","reservation_id":"73950","confirmation_number":"PB12290883509","room_confirmation_number":"PB12343233801","room_stay_from":"2019-06-08","room_stay_to":"2019-06-15","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":"84555","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-03 18:03:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84555","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":"2961272","reservation_id":"73950","confirmation_number":"PB12254816981","room_confirmation_number":"PB12334946299","room_stay_from":"2019-06-08","room_stay_to":"2019-06-15","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":"84555","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-03 18:03:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84555","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":"2962472","reservation_id":"74131","confirmation_number":"PB12220947133","room_confirmation_number":"PB12314895758","room_stay_from":"2019-06-09","room_stay_to":"2019-06-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"84672","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-05 22:00:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84672","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":"2968883","reservation_id":"75160","confirmation_number":"PB12253514566","room_confirmation_number":"PB12365188705","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"85253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-23 00:27:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85253","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":"2968885","reservation_id":"75160","confirmation_number":"PB12254566814","room_confirmation_number":"PB12365228839","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"85253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-23 00:27:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85253","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":"2974537","reservation_id":"76050","confirmation_number":"PB12266493240","room_confirmation_number":"PB12366537272","room_stay_from":"2019-06-08","room_stay_to":"2019-06-12","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"85768","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-05-09 00:42:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85768","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":"2976227","reservation_id":"76374","confirmation_number":"BV12298666760","room_confirmation_number":"BV12443214292","room_stay_from":"2019-06-09","room_stay_to":"2019-06-16","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":"85989","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-13 20:37:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85989","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":"2979010","reservation_id":"76934","confirmation_number":"PB12262159345","room_confirmation_number":"PB12329660198","room_stay_from":"2019-06-09","room_stay_to":"2019-06-11","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":"86422","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-05-20 16:22:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86422","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":"2980919","reservation_id":"77317","confirmation_number":"BV12297889411","room_confirmation_number":"BV12466590545","room_stay_from":"2019-06-08","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"86719","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-25 18:03:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86719","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":"2984232","reservation_id":"75224","confirmation_number":"PB12262502419","room_confirmation_number":"PB12390665476","room_stay_from":"2019-06-03","room_stay_to":"2019-06-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"47007","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-24 03:45:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47007","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":"2985014","reservation_id":"78128","confirmation_number":"BP12230123565","room_confirmation_number":"BP12571082165","room_stay_from":"2019-06-09","room_stay_to":"2019-06-14","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":"87291","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-06 18:36:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87291","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":"2985018","reservation_id":"67279","confirmation_number":"PB12288264139","room_confirmation_number":"PB12376265242","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"80332","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-19 18:02:27","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80332","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":"2985100","reservation_id":"74991","confirmation_number":"PB12293179647","room_confirmation_number":"PB12394085452","room_stay_from":"2019-06-06","room_stay_to":"2019-06-18","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"72285","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-19 20:35:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72285","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":"2985426","reservation_id":"30714","confirmation_number":"PB12362085326","room_confirmation_number":"PB973603549","room_stay_from":"2019-06-07","room_stay_to":"2019-06-12","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":"70629","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-05-06 17:06:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70629","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":"2985468","reservation_id":"30714","confirmation_number":"PB12394414129","room_confirmation_number":"PB935140457","room_stay_from":"2019-06-07","room_stay_to":"2019-06-12","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":"70629","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-05-06 17:06:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70629","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":"2985532","reservation_id":"71786","confirmation_number":"PB12269602759","room_confirmation_number":"PB12366644934","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83147","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-03-12 21:09:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83147","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":"2985620","reservation_id":"49341","confirmation_number":"PBR12277356242","room_confirmation_number":"PB12349205705","room_stay_from":"2019-06-07","room_stay_to":"2019-06-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23420","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23420","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":"2985754","reservation_id":"50129","confirmation_number":"PBR12258091055","room_confirmation_number":"PB12338494939","room_stay_from":"2019-06-07","room_stay_to":"2019-06-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"51959","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"51959","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":"2985829","reservation_id":"49163","confirmation_number":"PBR12260590830","room_confirmation_number":"PB12327682836","room_stay_from":"2019-06-07","room_stay_to":"2019-06-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24155","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24155","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":"2985962","reservation_id":"77580","confirmation_number":"BV12221392009","room_confirmation_number":"BV12468791296","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"86888","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-29 21:26:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86888","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":"2986035","reservation_id":"76450","confirmation_number":"PB12219729831","room_confirmation_number":"PB12335712208","room_stay_from":"2019-06-07","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"86062","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-14 23:42:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86062","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":"2986058","reservation_id":"65991","confirmation_number":"BP12216313094","room_confirmation_number":"BP12554688617","room_stay_from":"2019-06-08","room_stay_to":"2019-06-16","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"79675","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-08 21:02:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79675","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":"2986066","reservation_id":"49287","confirmation_number":"PBR12236756808","room_confirmation_number":"PB12385603873","room_stay_from":"2019-06-08","room_stay_to":"2019-06-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"24154","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"2018-06-17 21:40:57","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24154","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":"2986095","reservation_id":"76196","confirmation_number":"PB12296781016","room_confirmation_number":"PB12351348127","room_stay_from":"2019-06-08","room_stay_to":"2019-06-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"57906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-10 17:59:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"57906","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":"2986222","reservation_id":"74802","confirmation_number":"BP12294986393","room_confirmation_number":"BP12541956422","room_stay_from":"2019-06-08","room_stay_to":"2019-06-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79410","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-16 00:18:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79410","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":"2986246","reservation_id":"67279","confirmation_number":"PB12295540458","room_confirmation_number":"PB12378515570","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"80332","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-19 18:02:27","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80332","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":"2986250","reservation_id":"77964","confirmation_number":"PB12266088915","room_confirmation_number":"PB12378530650","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","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":"87156","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-04 18:17:27","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87156","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":"2986345","reservation_id":"49279","confirmation_number":"PBR12278254797","room_confirmation_number":"PB12378826051","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"71291","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71291","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":"2986347","reservation_id":"78185","confirmation_number":"BP12210021867","room_confirmation_number":"BP12552165585","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","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":"87325","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 14:15:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87325","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":"2986418","reservation_id":"78237","confirmation_number":"BP12272624358","room_confirmation_number":"BP12599279631","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87361","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-07 23:28:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87361","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":"2986437","reservation_id":"78330","confirmation_number":"BP12236053111","room_confirmation_number":"BP12547078574","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87417","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-09 17:21:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87417","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":"2986458","reservation_id":"78336","confirmation_number":"PB12252636894","room_confirmation_number":"PB12317143326","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"87421","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 17:57:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87421","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":"2986481","reservation_id":"73195","confirmation_number":"PB12296914414","room_confirmation_number":"PB12374539344","room_stay_from":"2019-06-09","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"84101","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-26 13:43:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84101","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":"2986519","reservation_id":"78333","confirmation_number":"BV12220321800","room_confirmation_number":"BV12493338987","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87419","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-09 17:32:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87419","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":"2986534","reservation_id":"78347","confirmation_number":"BV12279277734","room_confirmation_number":"BV12416959007","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87430","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-09 20:03:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87430","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":"2986544","reservation_id":"78350","confirmation_number":"PB12296074840","room_confirmation_number":"PB12319075885","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87433","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-09 20:32:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87433","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":"2986607","reservation_id":"76676","confirmation_number":"BP12235864209","room_confirmation_number":"BP12523489838","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","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":"50311","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-17 14:33:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50311","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":"2986614","reservation_id":"78359","confirmation_number":"PB12286985543","room_confirmation_number":"PB12335695811","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","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":"87439","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 22:07:58","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87439","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":"2986703","reservation_id":"78387","confirmation_number":"PB12215206012","room_confirmation_number":"PB12369997817","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","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":"87458","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-10 02:31:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87458","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":"2987811","reservation_id":"49098","confirmation_number":"PBR12215082364","room_confirmation_number":"PB12370255816","room_stay_from":"2019-06-03","room_stay_to":"2019-06-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"28346","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28346","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":"2987985","reservation_id":"49248","confirmation_number":"PBR12290905570","room_confirmation_number":"PB12375249256","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","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":"71278","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71278","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":"2988614","reservation_id":"67751","confirmation_number":"PB12232807318","room_confirmation_number":"PB12380644057","room_stay_from":"2019-06-05","room_stay_to":"2019-06-16","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26113","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-25 00:32:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26113","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":"2988779","reservation_id":"49225","confirmation_number":"PB12318589304","room_confirmation_number":"PB12362772148","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","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":"62154","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-06-20 12:38:45","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62154","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":"2985013","reservation_id":"78128","confirmation_number":"BP12212284316","room_confirmation_number":"BP12571082165","room_stay_from":"2019-06-09","room_stay_to":"2019-06-14","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":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-06 18:36:43","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87291","parentCustTravId":"87291","customer_traveller_id":"87291","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2986479","reservation_id":"78333","confirmation_number":"BV12285800835","room_confirmation_number":"BV12444653532","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-06-09 18:32:48","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87419","parentCustTravId":"87419","customer_traveller_id":"87419","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":"2986482","reservation_id":"78333","confirmation_number":"PB12245258213","room_confirmation_number":"BV12493338987","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-06-09 18:33:10","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87419","parentCustTravId":"87419","customer_traveller_id":"87419","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":"2986483","reservation_id":"73195","confirmation_number":"PB12241793937","room_confirmation_number":"PB12374539344","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1156","service_quantity":"2","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-09 18:36:18","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"84101","parentCustTravId":"84101","customer_traveller_id":"84101","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2986577","reservation_id":"77828","confirmation_number":"BP12255695057","room_confirmation_number":"BV12461603372","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"118.65","paid_amount":"118.65","product_id":"1212","service_quantity":"7","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-09 21:05:45","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87052","parentCustTravId":"87052","customer_traveller_id":"87052","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"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":12,"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":"2948298","reservation_id":"71786","confirmation_number":"PB12381625692","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.60,222.60,192.60,192.60","nightly_discount":"0,0,0,0","subtotal":"830.40","grand_total":"938.35","paid_amount":"938.35","room_type_id":"289","product_id":"1096","siteminder_id":"BDC-1153921792","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":"83147","customer_id":"83147","source_of_creation":"Booking.com","reservation_created_date":"2019-03-12 21:09:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"243.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"192.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":"2979009","reservation_id":"76934","confirmation_number":"PB12329660198","room_stay_from":"2019-06-09","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.85,181.85","nightly_discount":"0,0","subtotal":"363.70","grand_total":"410.98","paid_amount":"410.98","room_type_id":"286","product_id":"1086","siteminder_id":"BDC-2389477332","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":"86422","customer_id":"86422","source_of_creation":"Booking.com","reservation_created_date":"2019-05-20 16:22:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"54.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"181.85","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":"2985529","reservation_id":"71786","confirmation_number":"PB12366644934","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"213.60,213.60,183.60,183.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"794.40","grand_total":"897.67","paid_amount":"897.67","room_type_id":"289","product_id":"1095","siteminder_id":"BDC-1153921792","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":"83147","customer_id":"83147","source_of_creation":"Booking.com","reservation_created_date":"2019-03-12 21:09:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"243.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2920824","reservation_id":"67270","confirmation_number":"PB12361036361","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.20,177.60,177.60,139.20","nightly_discount":"0,0,0,0","subtotal":"633.60","grand_total":"715.97","paid_amount":"715.97","room_type_id":"289","product_id":"1106","siteminder_id":"EXP-1182580156","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":"80559","customer_id":"80559","source_of_creation":"Expedia","reservation_created_date":"2019-01-19 16:40:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2974536","reservation_id":"76050","confirmation_number":"PB12366537272","room_stay_from":"2019-06-08","room_stay_to":"2019-06-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.22,73.22,73.22,73.22","nightly_discount":"0,0,0,0","subtotal":"292.88","grand_total":"330.95","paid_amount":"330.95","room_type_id":"291","product_id":"1115","siteminder_id":"HTN-84079303-MEMTY4","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":"85768","customer_id":"85768","source_of_creation":"HotelTonight","reservation_created_date":"2019-05-09 00:42:10","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":"73.22","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":"2986543","reservation_id":"78350","confirmation_number":"PB12319075885","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.51","nightly_discount":"0","subtotal":"81.51","grand_total":"92.11","paid_amount":"92.11","room_type_id":"289","product_id":"1104","siteminder_id":"HTN-87409200-LX9DCZ","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":"87433","customer_id":"87433","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-09 20:32:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"81.51","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2984231","reservation_id":"75224","confirmation_number":"PB12390665476","room_stay_from":"2019-06-03","room_stay_to":"2019-06-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"169.00,169.00,169.00,169.00,169.00,169.00,169.00,178.00,178.00","nightly_discount":"91.35,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1539.00","grand_total":"1635.85","paid_amount":"1635.85","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":"47007","customer_id":"47007","source_of_creation":"FE","reservation_created_date":"2019-04-24 03:45:51","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":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986094","reservation_id":"76196","confirmation_number":"PB12351348127","room_stay_from":"2019-06-08","room_stay_to":"2019-06-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.90,141.84,141.84,141.84,141.84,141.84,172.90,172.90,141.84","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,73.87,0.00","subtotal":"1369.74","grand_total":"1464.33","paid_amount":"1464.33","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":"57906","customer_id":"57906","source_of_creation":"FE","reservation_created_date":"2019-05-10 17:59:52","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":"141.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"124248","reservation_id":"48973","confirmation_number":"PB12377478985","room_stay_from":"2019-06-04","room_stay_to":"2019-06-25","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,109.00,109.00,109.00,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,0.00,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":"2289.00","grand_total":"2586.57","paid_amount":"2586.57","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":"71132","customer_id":"71132","source_of_creation":"PMS","reservation_created_date":"2018-06-13 16:11:13","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 104","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":"124250","reservation_id":"48972","confirmation_number":"PB12360803854","room_stay_from":"2019-06-04","room_stay_to":"2019-06-25","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,109.00,109.00,109.00,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,0.00,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":"2289.00","grand_total":"2586.57","paid_amount":"2586.57","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":"71131","customer_id":"71131","source_of_creation":"PMS","reservation_created_date":"2018-06-13 15:57:50","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 106","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":"2880839","reservation_id":"59146","confirmation_number":"PB12352409290","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.00,225.00,225.00,175.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"800.00","grand_total":"904.00","paid_amount":"904.00","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76392","customer_id":"76392","source_of_creation":"PMS","reservation_created_date":"2018-10-28 12:27:00","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":"175.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961269","reservation_id":"73950","confirmation_number":"PB12343233801","room_stay_from":"2019-06-08","room_stay_to":"2019-06-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,85.50,85.50,85.50,85.50,85.50,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"647.50","grand_total":"731.68","paid_amount":"731.68","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84555","customer_id":"84555","source_of_creation":"PMS","reservation_created_date":"2019-04-03 18:03:55","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961271","reservation_id":"73950","confirmation_number":"PB12334946299","room_stay_from":"2019-06-08","room_stay_to":"2019-06-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,85.50,85.50,85.50,85.50,85.50,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"647.50","grand_total":"731.68","paid_amount":"731.68","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84555","customer_id":"84555","source_of_creation":"PMS","reservation_created_date":"2019-04-03 18:03:55","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":"85.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962471","reservation_id":"74131","confirmation_number":"PB12314895758","room_stay_from":"2019-06-09","room_stay_to":"2019-06-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.00,197.00,197.00,197.00,197.00,247.00,247.00,197.00,197.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1873.00","grand_total":"2116.49","paid_amount":"2116.49","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84672","customer_id":"84672","source_of_creation":"PMS","reservation_created_date":"2019-04-05 22:00:40","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"197.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2968882","reservation_id":"75160","confirmation_number":"PB12365188705","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"283.00,233.00,233.00","nightly_discount":"0.00,0.00,0.00","subtotal":"749.00","grand_total":"846.37","paid_amount":"846.37","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85253","customer_id":"85253","source_of_creation":"PMS","reservation_created_date":"2019-04-23 00:27:51","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"233.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2968884","reservation_id":"75160","confirmation_number":"PB12365228839","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"283.00,233.00,233.00","nightly_discount":"0.00,0.00,0.00","subtotal":"749.00","grand_total":"846.37","paid_amount":"846.37","room_type_id":"288","product_id":"1092","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85253","customer_id":"85253","source_of_creation":"PMS","reservation_created_date":"2019-04-23 00:27:52","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"233.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985017","reservation_id":"67279","confirmation_number":"PB12376265242","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.40,242.40,242.40,242.40","nightly_discount":"0.00,0.00,29.43,0.00","subtotal":"929.60","grand_total":"1017.19","paid_amount":"1017.19","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":"80332","customer_id":"80332","source_of_creation":"PMS","reservation_created_date":"2019-01-19 18:02:27","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":"242.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985099","reservation_id":"74991","confirmation_number":"PB12394085452","room_stay_from":"2019-06-06","room_stay_to":"2019-06-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.00,169.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,92.94,0.00","subtotal":"2028.00","grand_total":"2186.61","paid_amount":"2186.61","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":"72285","customer_id":"72285","source_of_creation":"PMS","reservation_created_date":"2019-04-19 20:35:42","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":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985619","reservation_id":"49341","confirmation_number":"PB12349205705","room_stay_from":"2019-06-07","room_stay_to":"2019-06-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00","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,108.26,0.00","subtotal":"2055.00","grand_total":"2199.81","paid_amount":"2199.81","room_type_id":"292","product_id":"1120","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23420","customer_id":"23420","source_of_creation":"PMS","reservation_created_date":"2018-06-18 20:11:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985753","reservation_id":"50129","confirmation_number":"PB12338494939","room_stay_from":"2019-06-07","room_stay_to":"2019-06-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00,225.00,225.00,225.00,225.00,225.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,121.10,0.00","subtotal":"2250.00","grand_total":"2405.65","paid_amount":"2405.65","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":"51959","customer_id":"51959","source_of_creation":"PMS","reservation_created_date":"2018-07-01 15:06:55","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985828","reservation_id":"49163","confirmation_number":"PB12327682836","room_stay_from":"2019-06-07","room_stay_to":"2019-06-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.45,135.45,135.45,135.45,135.45,135.45,135.45,135.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,54.35,0.00","subtotal":"1083.60","grand_total":"1163.06","paid_amount":"1163.06","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":"24155","customer_id":"24155","source_of_creation":"PMS","reservation_created_date":"2018-06-16 00:20:24","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.45","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986034","reservation_id":"76450","confirmation_number":"PB12335712208","room_stay_from":"2019-06-07","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.48,116.48,91.01","nightly_discount":"0.00,0.00,0.00","subtotal":"323.97","grand_total":"366.09","paid_amount":"311.85","room_type_id":"290","product_id":"1113","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86062","customer_id":"86062","source_of_creation":"PMS","reservation_created_date":"2019-05-14 23:42:40","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.01","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986065","reservation_id":"49287","confirmation_number":"PB12385603873","room_stay_from":"2019-06-08","room_stay_to":"2019-06-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"132.00,132.00,132.00,132.00,132.00,132.00,132.00,132.00,132.00,132.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,74.37,0.00","subtotal":"1320.00","grand_total":"1407.56","paid_amount":"1407.56","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":"24154","customer_id":"24154","source_of_creation":"PMS","reservation_created_date":"2018-06-17 21:40:57","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":"132.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986245","reservation_id":"67279","confirmation_number":"PB12378515570","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.40,242.40,242.40,242.40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"929.60","grand_total":"1050.45","paid_amount":"1050.45","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80332","customer_id":"80332","source_of_creation":"PMS","reservation_created_date":"2019-01-19 18:02:27","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"242.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986249","reservation_id":"77964","confirmation_number":"PB12378530650","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87156","customer_id":"87156","source_of_creation":"PMS","reservation_created_date":"2019-06-04 18:17:27","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":"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":"2986344","reservation_id":"49279","confirmation_number":"PB12378826051","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,76.78,0.00","subtotal":"1251.00","grand_total":"1326.87","paid_amount":"1326.87","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":"71291","customer_id":"71291","source_of_creation":"PMS","reservation_created_date":"2018-06-17 20:34:20","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986457","reservation_id":"78336","confirmation_number":"PB12317143326","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"139.00","nightly_discount":"0.00","subtotal":"139.00","grand_total":"157.07","paid_amount":"157.07","room_type_id":"289","product_id":"1103","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87421","customer_id":"87421","source_of_creation":"PMS","reservation_created_date":"2019-06-09 17:57:21","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":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986480","reservation_id":"73195","confirmation_number":"PB12374539344","room_stay_from":"2019-06-09","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"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":"84101","customer_id":"84101","source_of_creation":"PMS","reservation_created_date":"2019-03-26 13:43:19","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":"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":"2986613","reservation_id":"78359","confirmation_number":"PB12335695811","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00","nightly_discount":"0.00","subtotal":"139.00","grand_total":"157.07","paid_amount":"157.07","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":"87439","customer_id":"87439","source_of_creation":"PMS","reservation_created_date":"2019-06-09 22:07:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986702","reservation_id":"78387","confirmation_number":"PB12369997817","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00","nightly_discount":"0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","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":"87458","customer_id":"87458","source_of_creation":"PMS","reservation_created_date":"2019-06-10 02:31:51","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":"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":"2987810","reservation_id":"49098","confirmation_number":"PB12370255816","room_stay_from":"2019-06-03","room_stay_to":"2019-06-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1430.00","grand_total":"1615.90","paid_amount":"1615.90","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28346","customer_id":"28346","source_of_creation":"PMS","reservation_created_date":"2018-06-15 13:06:56","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2987984","reservation_id":"49248","confirmation_number":"PB12375249256","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.00,136.00,136.00,136.00,136.00,136.00,136.00,136.00,136.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,61.00","subtotal":"1224.00","grand_total":"1314.19","paid_amount":"1344.70","room_type_id":"285","product_id":"1083","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":"71278","customer_id":"71278","source_of_creation":"PMS","reservation_created_date":"2018-06-17 16:01:56","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":"136.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2988613","reservation_id":"67751","confirmation_number":"PB12380644057","room_stay_from":"2019-06-05","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00,131.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1441.00","grand_total":"1628.33","paid_amount":"1628.33","room_type_id":"289","product_id":"1109","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":"26113","customer_id":"26113","source_of_creation":"PMS","reservation_created_date":"2019-01-25 00:32:35","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":"131.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2988778","reservation_id":"49225","confirmation_number":"PB12362772148","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.00,136.00,136.00,136.00,136.00,136.00,136.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,68.30,0.00","subtotal":"1220.00","grand_total":"1301.42","paid_amount":"1301.42","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":"62154","customer_id":"62154","source_of_creation":"PMS","reservation_created_date":"2018-06-16 22:41:40","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2970264","reservation_id":"75224","confirmation_number":"PB12256440555","room_confirmation_number":"PB12390665476","room_stay_from":"2019-06-03","room_stay_to":"2019-06-12","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"47007","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-04-26 21:18:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47007","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2985531","reservation_id":"71786","confirmation_number":"PB12244088074","room_confirmation_number":"PB12366644934","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0,0,0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"83147","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-07 19:23:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83147","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":"2986459","reservation_id":"78336","confirmation_number":"PB12256461011","room_confirmation_number":"PB12317143326","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"10.00","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"87421","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-09 17:57:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87421","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898886","reservation_id":"59146","confirmation_number":"PBR12273574624","room_confirmation_number":"PB12352409290","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"76392","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76392","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2920825","reservation_id":"67270","confirmation_number":"PB12291978310","room_confirmation_number":"PB12361036361","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"80559","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-19 16:40:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80559","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":"2927922","reservation_id":"48973","confirmation_number":"PB12378722258","room_confirmation_number":"PB12377478985","room_stay_from":"2019-06-04","room_stay_to":"2019-06-25","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"71132","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-06-15 07:59:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71132","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2927923","reservation_id":"48972","confirmation_number":"PB12339615634","room_confirmation_number":"PB12360803854","room_stay_from":"2019-06-04","room_stay_to":"2019-06-25","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"71131","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-06-15 08:02:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71131","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2948299","reservation_id":"71786","confirmation_number":"PB12257871279","room_confirmation_number":"PB12381625692","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83147","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-03-12 21:09:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83147","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":"2961270","reservation_id":"73950","confirmation_number":"PB12290883509","room_confirmation_number":"PB12343233801","room_stay_from":"2019-06-08","room_stay_to":"2019-06-15","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":"84555","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-03 18:03:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84555","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":"2961272","reservation_id":"73950","confirmation_number":"PB12254816981","room_confirmation_number":"PB12334946299","room_stay_from":"2019-06-08","room_stay_to":"2019-06-15","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":"84555","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-03 18:03:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84555","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":"2962472","reservation_id":"74131","confirmation_number":"PB12220947133","room_confirmation_number":"PB12314895758","room_stay_from":"2019-06-09","room_stay_to":"2019-06-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"84672","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-05 22:00:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84672","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":"2968883","reservation_id":"75160","confirmation_number":"PB12253514566","room_confirmation_number":"PB12365188705","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"85253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-23 00:27:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85253","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":"2968885","reservation_id":"75160","confirmation_number":"PB12254566814","room_confirmation_number":"PB12365228839","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"85253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-23 00:27:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85253","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":"2974537","reservation_id":"76050","confirmation_number":"PB12266493240","room_confirmation_number":"PB12366537272","room_stay_from":"2019-06-08","room_stay_to":"2019-06-12","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"85768","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-05-09 00:42:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85768","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":"2979010","reservation_id":"76934","confirmation_number":"PB12262159345","room_confirmation_number":"PB12329660198","room_stay_from":"2019-06-09","room_stay_to":"2019-06-11","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":"86422","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-05-20 16:22:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86422","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":"2984232","reservation_id":"75224","confirmation_number":"PB12262502419","room_confirmation_number":"PB12390665476","room_stay_from":"2019-06-03","room_stay_to":"2019-06-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"47007","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-24 03:45:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47007","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":"2985018","reservation_id":"67279","confirmation_number":"PB12288264139","room_confirmation_number":"PB12376265242","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"80332","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-19 18:02:27","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80332","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":"2985100","reservation_id":"74991","confirmation_number":"PB12293179647","room_confirmation_number":"PB12394085452","room_stay_from":"2019-06-06","room_stay_to":"2019-06-18","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"72285","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-19 20:35:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72285","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":"2985532","reservation_id":"71786","confirmation_number":"PB12269602759","room_confirmation_number":"PB12366644934","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83147","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-03-12 21:09:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83147","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":"2985620","reservation_id":"49341","confirmation_number":"PBR12277356242","room_confirmation_number":"PB12349205705","room_stay_from":"2019-06-07","room_stay_to":"2019-06-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23420","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23420","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":"2985754","reservation_id":"50129","confirmation_number":"PBR12258091055","room_confirmation_number":"PB12338494939","room_stay_from":"2019-06-07","room_stay_to":"2019-06-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"51959","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"51959","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":"2985829","reservation_id":"49163","confirmation_number":"PBR12260590830","room_confirmation_number":"PB12327682836","room_stay_from":"2019-06-07","room_stay_to":"2019-06-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24155","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24155","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":"2986035","reservation_id":"76450","confirmation_number":"PB12219729831","room_confirmation_number":"PB12335712208","room_stay_from":"2019-06-07","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"86062","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-14 23:42:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86062","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":"2986066","reservation_id":"49287","confirmation_number":"PBR12236756808","room_confirmation_number":"PB12385603873","room_stay_from":"2019-06-08","room_stay_to":"2019-06-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"24154","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"2018-06-17 21:40:57","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24154","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":"2986095","reservation_id":"76196","confirmation_number":"PB12296781016","room_confirmation_number":"PB12351348127","room_stay_from":"2019-06-08","room_stay_to":"2019-06-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"57906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-10 17:59:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"57906","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":"2986246","reservation_id":"67279","confirmation_number":"PB12295540458","room_confirmation_number":"PB12378515570","room_stay_from":"2019-06-06","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"80332","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-19 18:02:27","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80332","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":"2986250","reservation_id":"77964","confirmation_number":"PB12266088915","room_confirmation_number":"PB12378530650","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","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":"87156","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-04 18:17:27","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87156","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":"2986345","reservation_id":"49279","confirmation_number":"PBR12278254797","room_confirmation_number":"PB12378826051","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"71291","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71291","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":"2986458","reservation_id":"78336","confirmation_number":"PB12252636894","room_confirmation_number":"PB12317143326","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"87421","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 17:57:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87421","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":"2986481","reservation_id":"73195","confirmation_number":"PB12296914414","room_confirmation_number":"PB12374539344","room_stay_from":"2019-06-09","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"84101","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-26 13:43:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84101","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":"2986544","reservation_id":"78350","confirmation_number":"PB12296074840","room_confirmation_number":"PB12319075885","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87433","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-09 20:32:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87433","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":"2986614","reservation_id":"78359","confirmation_number":"PB12286985543","room_confirmation_number":"PB12335695811","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","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":"87439","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 22:07:58","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87439","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":"2986703","reservation_id":"78387","confirmation_number":"PB12215206012","room_confirmation_number":"PB12369997817","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","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":"87458","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-10 02:31:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87458","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":"2987811","reservation_id":"49098","confirmation_number":"PBR12215082364","room_confirmation_number":"PB12370255816","room_stay_from":"2019-06-03","room_stay_to":"2019-06-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"28346","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28346","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":"2987985","reservation_id":"49248","confirmation_number":"PBR12290905570","room_confirmation_number":"PB12375249256","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","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":"71278","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71278","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":"2988614","reservation_id":"67751","confirmation_number":"PB12232807318","room_confirmation_number":"PB12380644057","room_stay_from":"2019-06-05","room_stay_to":"2019-06-16","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26113","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-25 00:32:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26113","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":"2988779","reservation_id":"49225","confirmation_number":"PB12318589304","room_confirmation_number":"PB12362772148","room_stay_from":"2019-06-07","room_stay_to":"2019-06-16","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":"62154","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-06-20 12:38:45","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62154","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":"2986483","reservation_id":"73195","confirmation_number":"PB12241793937","room_confirmation_number":"PB12374539344","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1156","service_quantity":"2","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-09 18:36:18","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"84101","parentCustTravId":"84101","customer_traveller_id":"84101","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":9,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2986533","reservation_id":"78347","confirmation_number":"BV12416959007","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.72","nightly_discount":"0","subtotal":"81.72","grand_total":"92.34","paid_amount":"92.34","room_type_id":"303","product_id":"1139","siteminder_id":"EXP-1274460737","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":"87430","customer_id":"87430","source_of_creation":"Expedia","reservation_created_date":"2019-06-09 20:03:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"81.72","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":"2986518","reservation_id":"78333","confirmation_number":"BV12493338987","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"54.53","nightly_discount":"0.00","subtotal":"54.53","grand_total":"61.62","paid_amount":"61.62","room_type_id":"289","product_id":"1112","siteminder_id":"HTN-87392710-JWJWGA","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":"87419","customer_id":"87419","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-09 17:32:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"54.53","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2976226","reservation_id":"76374","confirmation_number":"BV12443214292","room_stay_from":"2019-06-09","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.24,138.24,138.24,138.24,138.24,169.40,169.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1030.00","grand_total":"1163.90","paid_amount":"1163.90","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85989","customer_id":"85989","source_of_creation":"PMS","reservation_created_date":"2019-05-13 20:37:10","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2980918","reservation_id":"77317","confirmation_number":"BV12466590545","room_stay_from":"2019-06-08","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.50,133.20","nightly_discount":"0.00,0.00","subtotal":"297.70","grand_total":"336.40","paid_amount":"336.40","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":"86719","customer_id":"86719","source_of_creation":"PMS","reservation_created_date":"2019-05-25 18:03:55","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":"133.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":"2985961","reservation_id":"77580","confirmation_number":"BV12468791296","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"155.40,100.31,100.31","nightly_discount":"0.00,16.33,0.00","subtotal":"356.02","grand_total":"383.85","paid_amount":"383.85","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86888","customer_id":"86888","source_of_creation":"PMS","reservation_created_date":"2019-05-29 21:26:12","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.31","currentDayDiscount":"16.33","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2982435","reservation_id":"77580","confirmation_number":"BV12219527275","room_confirmation_number":"BV12468791296","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"86888","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-05-29 21:26:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86888","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2976227","reservation_id":"76374","confirmation_number":"BV12298666760","room_confirmation_number":"BV12443214292","room_stay_from":"2019-06-09","room_stay_to":"2019-06-16","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":"85989","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-13 20:37:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85989","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":"2980919","reservation_id":"77317","confirmation_number":"BV12297889411","room_confirmation_number":"BV12466590545","room_stay_from":"2019-06-08","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"86719","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-25 18:03:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86719","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":"2985962","reservation_id":"77580","confirmation_number":"BV12221392009","room_confirmation_number":"BV12468791296","room_stay_from":"2019-06-08","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"86888","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-29 21:26:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86888","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":"2986519","reservation_id":"78333","confirmation_number":"BV12220321800","room_confirmation_number":"BV12493338987","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87419","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-09 17:32:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87419","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":"2986534","reservation_id":"78347","confirmation_number":"BV12279277734","room_confirmation_number":"BV12416959007","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87430","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-09 20:03:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87430","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2986479","reservation_id":"78333","confirmation_number":"BV12285800835","room_confirmation_number":"BV12444653532","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-06-09 18:32:48","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87419","parentCustTravId":"87419","customer_traveller_id":"87419","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":"2986482","reservation_id":"78333","confirmation_number":"PB12245258213","room_confirmation_number":"BV12493338987","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-06-09 18:33:10","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87419","parentCustTravId":"87419","customer_traveller_id":"87419","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":"2986577","reservation_id":"77828","confirmation_number":"BP12255695057","room_confirmation_number":"BV12461603372","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"118.65","paid_amount":"118.65","product_id":"1212","service_quantity":"7","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-09 21:05:45","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87052","parentCustTravId":"87052","customer_traveller_id":"87052","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":12,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2986417","reservation_id":"78237","confirmation_number":"BP12599279631","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.00","nightly_discount":"0.00","subtotal":"88.00","grand_total":"99.44","paid_amount":"99.44","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1273444172","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":"87361","customer_id":"87361","source_of_creation":"Expedia","reservation_created_date":"2019-06-07 23:28:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2986436","reservation_id":"78330","confirmation_number":"BP12547078574","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.93","nightly_discount":"0","subtotal":"69.93","grand_total":"79.03","paid_amount":"79.03","room_type_id":"298","product_id":"1133","siteminder_id":"GAM-R1531287164","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":"87417","customer_id":"87417","source_of_creation":"Getaroom.com","reservation_created_date":"2019-06-09 17:21:06","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":"69.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2985012","reservation_id":"78128","confirmation_number":"BP12571082165","room_stay_from":"2019-06-09","room_stay_to":"2019-06-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","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","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":"87291","customer_id":"87291","source_of_creation":"PMS","reservation_created_date":"2019-06-06 18:36:43","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2986057","reservation_id":"65991","confirmation_number":"BP12554688617","room_stay_from":"2019-06-08","room_stay_to":"2019-06-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.40,146.97,146.97,146.97,146.97,146.97,211.40,211.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,147.00,0.00","subtotal":"1369.05","grand_total":"1380.91","paid_amount":"1380.91","room_type_id":"297","product_id":"1132","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79675","customer_id":"79675","source_of_creation":"PMS","reservation_created_date":"2019-01-08 21:02:13","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"146.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986221","reservation_id":"74802","confirmation_number":"BP12541956422","room_stay_from":"2019-06-08","room_stay_to":"2019-06-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.00,135.00,135.00,135.00,135.00","nightly_discount":"0.00,0.00,0.00,0.00,33.63,0.00","subtotal":"729.00","grand_total":"785.77","paid_amount":"785.77","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79410","customer_id":"79410","source_of_creation":"PMS","reservation_created_date":"2019-04-16 00:18:05","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986346","reservation_id":"78185","confirmation_number":"BP12552165585","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00","nightly_discount":"0.00","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87325","customer_id":"87325","source_of_creation":"PMS","reservation_created_date":"2019-06-09 14:15:11","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2986606","reservation_id":"76676","confirmation_number":"BP12523489838","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"139.30,139.30,107.28,69.00","nightly_discount":"0.00,0.00,17.65,3.51,0.00","subtotal":"454.88","grand_total":"490.10","paid_amount":"490.10","room_type_id":"293","product_id":"1124","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":"50311","customer_id":"50311","source_of_creation":"PMS","reservation_created_date":"2019-05-17 14:33:07","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":"107.28","currentDayDiscount":"17.65","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2986605","reservation_id":"76676","confirmation_number":"BP12266543247","room_confirmation_number":"BP12523489838","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"50311","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-06-09 21:26:26","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50311","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2985014","reservation_id":"78128","confirmation_number":"BP12230123565","room_confirmation_number":"BP12571082165","room_stay_from":"2019-06-09","room_stay_to":"2019-06-14","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":"87291","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-06 18:36:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87291","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":"2986058","reservation_id":"65991","confirmation_number":"BP12216313094","room_confirmation_number":"BP12554688617","room_stay_from":"2019-06-08","room_stay_to":"2019-06-16","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"79675","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-08 21:02:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79675","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":"2986222","reservation_id":"74802","confirmation_number":"BP12294986393","room_confirmation_number":"BP12541956422","room_stay_from":"2019-06-08","room_stay_to":"2019-06-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79410","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-16 00:18:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79410","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":"2986347","reservation_id":"78185","confirmation_number":"BP12210021867","room_confirmation_number":"BP12552165585","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","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":"87325","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 14:15:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87325","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":"2986418","reservation_id":"78237","confirmation_number":"BP12272624358","room_confirmation_number":"BP12599279631","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87361","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-07 23:28:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87361","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":"2986437","reservation_id":"78330","confirmation_number":"BP12236053111","room_confirmation_number":"BP12547078574","room_stay_from":"2019-06-09","room_stay_to":"2019-06-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87417","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-09 17:21:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87417","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":"2986607","reservation_id":"76676","confirmation_number":"BP12235864209","room_confirmation_number":"BP12523489838","room_stay_from":"2019-06-07","room_stay_to":"2019-06-11","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":"50311","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-17 14:33:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50311","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":"2985013","reservation_id":"78128","confirmation_number":"BP12212284316","room_confirmation_number":"BP12571082165","room_stay_from":"2019-06-09","room_stay_to":"2019-06-14","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":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-06 18:36:43","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"87291","parentCustTravId":"87291","customer_traveller_id":"87291","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}