{"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":"2991146","reservation_id":"79442","confirmation_number":"PB12367880216","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.39,173.39,173.39","nightly_discount":"0,0,0","subtotal":"520.17","grand_total":"587.79","paid_amount":"587.79","room_type_id":"289","product_id":"1105","siteminder_id":"BDC-3203474843","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":"88022","customer_id":"88022","source_of_creation":"Booking.com","reservation_created_date":"2019-06-23 01:24:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"87.03","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.39","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":"3001780","reservation_id":"76263","confirmation_number":"PB12336729991","room_stay_from":"2019-07-23","room_stay_to":"2019-07-30","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"160.25,160.25,160.25,163.41,163.41,160.25,160.25","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1128.07","grand_total":"1274.71","paid_amount":"1274.71","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3116089608","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"210.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85912","customer_id":"85912","source_of_creation":"Booking.com","reservation_created_date":"2019-05-11 17:11:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"200.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[{"room_stay_id":"2919390","reservation_id":"67181","confirmation_number":"PB12368490960","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"25.20,25.20,25.20,25.20","nightly_discount":"0,0,0,0","subtotal":"100.80","grand_total":"100.80","paid_amount":"28.48","room_type_id":"288","product_id":"1091","siteminder_id":"BDC-1890164028","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80507","customer_id":"80507","source_of_creation":"Booking.com","reservation_created_date":"2019-01-18 18:39:12","service_canceled_date_time":"2019-07-23 18:42:51","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"15.12","deltaChange":"3.28","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"2989615","reservation_id":"78939","confirmation_number":"PB12336030473","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"131,131,131,131","nightly_discount":"0,0,0,0","subtotal":"524.00","grand_total":"592.12","paid_amount":"592.12","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1281052291","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87864","customer_id":"87864","source_of_creation":"Expedia","reservation_created_date":"2019-06-19 00:40:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131","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":"2991779","reservation_id":"79570","confirmation_number":"PB12321386863","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"136,136,136,136","nightly_discount":"0,0,0,0","subtotal":"544.00","grand_total":"614.72","paid_amount":"614.72","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1285733643","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88122","customer_id":"88122","source_of_creation":"Expedia","reservation_created_date":"2019-06-25 16:04:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136","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":"2991782","reservation_id":"79571","confirmation_number":"PB12375406445","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"4","nightly_price":"131,131,131,131","nightly_discount":"0,0,0,0","subtotal":"524.00","grand_total":"592.12","paid_amount":"592.12","room_type_id":"289","product_id":"1121","siteminder_id":"EXP-1285733644","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88123","customer_id":"88123","source_of_creation":"Expedia","reservation_created_date":"2019-06-25 16:04:14","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":"131","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":"2992948","reservation_id":"79797","confirmation_number":"PB12348374270","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.77,155.77,155.77","nightly_discount":"0,0,0","subtotal":"467.31","grand_total":"528.06","paid_amount":"528.06","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1288159671","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":"88293","customer_id":"88293","source_of_creation":"Expedia","reservation_created_date":"2019-06-28 18:44:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"155.77","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":"2999544","reservation_id":"80862","confirmation_number":"PB12345354449","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"120.97","nightly_discount":"0","subtotal":"120.97","grand_total":"136.70","paid_amount":"136.70","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1302040960","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89028","customer_id":"89028","source_of_creation":"Expedia","reservation_created_date":"2019-07-17 16:10:11","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":"120.97","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":"2999996","reservation_id":"78604","confirmation_number":"PB12372532499","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"91.15,88.82,88.82,88.82,88.82,88.82","nightly_discount":"0,0,0,0,0,0","subtotal":"535.25","grand_total":"604.84","paid_amount":"604.84","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1277256062","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"180.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87629","customer_id":"87629","source_of_creation":"Expedia","reservation_created_date":"2019-06-13 14:15:06","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":"88.82","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":"3001883","reservation_id":"80801","confirmation_number":"PB12362538268","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.02,132.02,132.02","nightly_discount":"0.00,0.00,0.00","subtotal":"396.06","grand_total":"447.54","paid_amount":"447.54","room_type_id":"289","product_id":"1099","siteminder_id":"EXP-1300742833","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":"88980","customer_id":"88980","source_of_creation":"Expedia","reservation_created_date":"2019-07-16 02:00:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2994789","reservation_id":"80085","confirmation_number":"PB12351339452","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.03","nightly_discount":"0","subtotal":"70.03","grand_total":"79.13","paid_amount":"79.13","room_type_id":"285","product_id":"1083","siteminder_id":"HTN-90233476-CP3T6P","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":"88507","customer_id":"88507","source_of_creation":"HotelTonight","reservation_created_date":"2019-07-03 07:21:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.03","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":"2994791","reservation_id":"80086","confirmation_number":"PB12390471328","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.02,49.02,49.02","nightly_discount":"0,0,0","subtotal":"147.06","grand_total":"166.17","paid_amount":"166.17","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-90235675-LREZG3","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":"88508","customer_id":"88508","source_of_creation":"HotelTonight","reservation_created_date":"2019-07-03 08:20:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001587","reservation_id":"79496","confirmation_number":"PB12321867331","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.69,49.02,49.02","nightly_discount":"0,0,0","subtotal":"162.73","grand_total":"183.88","paid_amount":"183.88","room_type_id":"289","product_id":"1098","siteminder_id":"HTN-89185316-PDLCVW","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":"88063","customer_id":"88063","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-24 02:47:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2989031","reservation_id":"78832","confirmation_number":"PB12372442856","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"215.46,215.46,215.46,215.46","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"861.84","grand_total":"973.88","paid_amount":"973.88","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":"87781","customer_id":"87781","source_of_creation":"FE","reservation_created_date":"2019-06-17 13:53:57","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":"215.46","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2937847","reservation_id":"58744","confirmation_number":"PB12395907853","room_stay_from":"2019-07-23","room_stay_to":"2019-08-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.00,162.00,162.00,162.00,162.00,162.00,162.00,162.00,162.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1458.00","grand_total":"1647.54","paid_amount":"1647.54","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":"26574","customer_id":"26574","source_of_creation":"PMS","reservation_created_date":"2018-10-23 14:18:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"162.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2979309","reservation_id":"77013","confirmation_number":"PB12347861077","room_stay_from":"2019-07-21","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"188.73,188.73,188.73,188.73,188.73","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"943.65","grand_total":"1066.33","paid_amount":"1066.33","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":"86487","customer_id":"86487","source_of_creation":"PMS","reservation_created_date":"2019-05-21 14:02:16","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2995512","reservation_id":"80243","confirmation_number":"PB12332610881","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","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":"88609","customer_id":"88609","source_of_creation":"PMS","reservation_created_date":"2019-07-05 21:03:40","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2995515","reservation_id":"80244","confirmation_number":"PB12371425668","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","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":"88609","customer_id":"88609","source_of_creation":"PMS","reservation_created_date":"2019-07-05 21:05:43","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":"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":"2995522","reservation_id":"80246","confirmation_number":"PB12332282682","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88609","customer_id":"88609","source_of_creation":"PMS","reservation_created_date":"2019-07-05 21:07:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2995525","reservation_id":"80247","confirmation_number":"PB12325928071","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"291","product_id":"1115","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88609","customer_id":"88609","source_of_creation":"PMS","reservation_created_date":"2019-07-05 21:08:54","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":"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":"2998336","reservation_id":"51651","confirmation_number":"PB12336577623","room_stay_from":"2019-07-13","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.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,106.60,0.00","subtotal":"2296.00","grand_total":"2474.02","paid_amount":"2474.02","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"27447","customer_id":"27447","source_of_creation":"PMS","reservation_created_date":"2018-07-21 15:14:40","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":"164.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2998340","reservation_id":"68024","confirmation_number":"PB12395019515","room_stay_from":"2019-07-13","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.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,106.60,0.00","subtotal":"2296.00","grand_total":"2474.02","paid_amount":"2474.02","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"27447","customer_id":"27447","source_of_creation":"PMS","reservation_created_date":"2019-01-28 17:10:19","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":"164.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001394","reservation_id":"78093","confirmation_number":"PB12359932233","room_stay_from":"2019-07-22","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.61,146.61,146.61","nightly_discount":"0.00,0.00,0.00","subtotal":"439.83","grand_total":"497.01","paid_amount":"497.01","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"42869","customer_id":"42869","source_of_creation":"PMS","reservation_created_date":"2019-06-06 01:32:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"146.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001681","reservation_id":"81012","confirmation_number":"PB12358676975","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.61,146.61,146.61,146.61","nightly_discount":"0.00,0.00,0.00,24.38,0.00","subtotal":"586.44","grand_total":"635.12","paid_amount":"635.12","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":"89127","customer_id":"89127","source_of_creation":"PMS","reservation_created_date":"2019-07-19 15:04:55","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":"146.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001689","reservation_id":"81191","confirmation_number":"PB12368527622","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00","nightly_discount":"0.00,0.00","subtotal":"220.00","grand_total":"248.60","paid_amount":"248.60","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":"89224","customer_id":"89224","source_of_creation":"PMS","reservation_created_date":"2019-07-22 13:24:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001853","reservation_id":"78516","confirmation_number":"PB12310541522","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00","nightly_discount":"0.00,0.00,5.43,0.00","subtotal":"477.00","grand_total":"532.87","paid_amount":"532.87","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":"87566","customer_id":"87566","source_of_creation":"PMS","reservation_created_date":"2019-06-12 10:30:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.00","currentDayDiscount":"5.43","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001945","reservation_id":"80360","confirmation_number":"PB12382904894","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"146.61,146.61,146.61,146.61","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"586.44","grand_total":"662.68","paid_amount":"662.68","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":"88667","customer_id":"88667","source_of_creation":"PMS","reservation_created_date":"2019-07-07 19:36:48","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"146.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007017","reservation_id":"81228","confirmation_number":"PB12349443835","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.95,90.95,90.95","nightly_discount":"0.00,0.00,0.00","subtotal":"272.85","grand_total":"308.32","paid_amount":"308.32","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":"78978","customer_id":"78978","source_of_creation":"PMS","reservation_created_date":"2019-07-22 21:55:40","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":"90.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007050","reservation_id":"81261","confirmation_number":"PB12324606953","room_stay_from":"2019-07-23","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.95,90.95","nightly_discount":"0.00,0.00","subtotal":"181.90","grand_total":"205.54","paid_amount":"205.54","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":"89275","customer_id":"89275","source_of_creation":"PMS","reservation_created_date":"2019-07-23 12:52:30","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007082","reservation_id":"81153","confirmation_number":"PB12399485406","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"112.11,112.11,112.10,112.10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"448.42","grand_total":"506.72","paid_amount":"506.72","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":"89194","customer_id":"89194","source_of_creation":"PMS","reservation_created_date":"2019-07-21 14:33:20","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":"112.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2979310","reservation_id":"77013","confirmation_number":"PB12224609211","room_confirmation_number":"PB12347861077","room_stay_from":"2019-07-21","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"86487","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-05-21 14:02:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86487","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":"2989033","reservation_id":"78832","confirmation_number":"PB12266130827","room_confirmation_number":"PB12372442856","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"87781","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-17 13:53:57","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87781","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":"2989616","reservation_id":"78939","confirmation_number":"PB12236422723","room_confirmation_number":"PB12336030473","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"87864","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-19 00:40:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87864","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":"2991780","reservation_id":"79570","confirmation_number":"PB12283584875","room_confirmation_number":"PB12321386863","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"88122","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-25 16:04: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":"88122","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2991783","reservation_id":"79571","confirmation_number":"PB12276576364","room_confirmation_number":"PB12375406445","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"88123","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-25 16:04:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88123","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":"2995514","reservation_id":"80243","confirmation_number":"PB12227536033","room_confirmation_number":"PB12332610881","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-05 21:03:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995516","reservation_id":"80244","confirmation_number":"PB12238213540","room_confirmation_number":"PB12371425668","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-05 21:05:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995523","reservation_id":"80246","confirmation_number":"PB12293809512","room_confirmation_number":"PB12332282682","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-05 21:07:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995526","reservation_id":"80247","confirmation_number":"PB12297469592","room_confirmation_number":"PB12325928071","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-05 21:08:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2996317","reservation_id":"78516","confirmation_number":"PB12297519041","room_confirmation_number":"PB12310541522","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"87566","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-07 23:28:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87566","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2999545","reservation_id":"80862","confirmation_number":"PB12243914273","room_confirmation_number":"PB12345354449","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"89028","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-17 16:10: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":"89028","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":"2999997","reservation_id":"78604","confirmation_number":"PB12265972187","room_confirmation_number":"PB12372532499","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"30,30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"87629","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-18 16:38:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87629","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":"3001569","reservation_id":"81153","confirmation_number":"PB12238015757","room_confirmation_number":"PB12399485406","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"89194","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-21 20:05:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89194","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":"3001781","reservation_id":"76263","confirmation_number":"PB12240279710","room_confirmation_number":"PB12336729991","room_stay_from":"2019-07-23","room_stay_to":"2019-07-30","room_stay_status":"Active","nightly_price":"30,30,30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"210.00","grand_total":"237.30","paid_amount":"237.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"85912","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-22 15:02:38","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85912","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":"3001946","reservation_id":"80360","confirmation_number":"PB12258316312","room_confirmation_number":"PB12382904894","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88667","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-22 18:44:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88667","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2937848","reservation_id":"58744","confirmation_number":"PB12330456223","room_confirmation_number":"PB12395907853","room_stay_from":"2019-07-23","room_stay_to":"2019-08-01","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0.00,0.00","nightly_discount":"0,0,0,0,0,0,0,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26574","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-10-26 19:54:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26574","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":"2979311","reservation_id":"77013","confirmation_number":"PB12286426384","room_confirmation_number":"PB12347861077","room_stay_from":"2019-07-21","room_stay_to":"2019-07-26","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":"86487","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-21 14:02:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86487","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":"2989032","reservation_id":"78832","confirmation_number":"PB12243086088","room_confirmation_number":"PB12372442856","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","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":"87781","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-17 13:53:57","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87781","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":"2989617","reservation_id":"78939","confirmation_number":"PB12271664976","room_confirmation_number":"PB12336030473","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"87864","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-19 00:40:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87864","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":"2991147","reservation_id":"79442","confirmation_number":"PB12232292478","room_confirmation_number":"PB12367880216","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88022","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-23 01:24:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88022","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":"2991781","reservation_id":"79570","confirmation_number":"PB12263320602","room_confirmation_number":"PB12321386863","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"88122","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-25 16:04: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":"88122","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":"2991784","reservation_id":"79571","confirmation_number":"PB12252169708","room_confirmation_number":"PB12375406445","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"88123","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-25 16:04:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88123","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":"2992949","reservation_id":"79797","confirmation_number":"PB12215397054","room_confirmation_number":"PB12348374270","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88293","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-28 18:44: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":"88293","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":"2994790","reservation_id":"80085","confirmation_number":"PB12234500399","room_confirmation_number":"PB12351339452","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"88507","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-03 07:21: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":"88507","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":"2994792","reservation_id":"80086","confirmation_number":"PB12273030021","room_confirmation_number":"PB12390471328","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88508","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-03 08:20:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88508","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":"2995513","reservation_id":"80243","confirmation_number":"PB12216314542","room_confirmation_number":"PB12332610881","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-05 21:03:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995517","reservation_id":"80244","confirmation_number":"PB12228504926","room_confirmation_number":"PB12371425668","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-05 21:05:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995524","reservation_id":"80246","confirmation_number":"PB12298792157","room_confirmation_number":"PB12332282682","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-05 21:07:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995527","reservation_id":"80247","confirmation_number":"PB12266967846","room_confirmation_number":"PB12325928071","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-05 21:08:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2998337","reservation_id":"51651","confirmation_number":"PBR12216653796","room_confirmation_number":"PB12336577623","room_stay_from":"2019-07-13","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27447","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":"27447","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":"2998341","reservation_id":"68024","confirmation_number":"PB12221648779","room_confirmation_number":"PB12395019515","room_stay_from":"2019-07-13","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27447","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-28 17:10:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27447","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":"2999546","reservation_id":"80862","confirmation_number":"PB12284149794","room_confirmation_number":"PB12345354449","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89028","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-17 16:10: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":"89028","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":"2999998","reservation_id":"78604","confirmation_number":"PB12244248829","room_confirmation_number":"PB12372532499","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87629","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-13 14:15: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":"87629","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":"3001395","reservation_id":"78093","confirmation_number":"PB12261600301","room_confirmation_number":"PB12359932233","room_stay_from":"2019-07-22","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"42869","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-06 01:32:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42869","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":"3001588","reservation_id":"79496","confirmation_number":"PB12219378912","room_confirmation_number":"PB12321867331","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88063","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-24 02:47:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88063","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":"3001682","reservation_id":"81012","confirmation_number":"PB12258647169","room_confirmation_number":"PB12358676975","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","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":"89127","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-19 15:04:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89127","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":"3001690","reservation_id":"81191","confirmation_number":"PB12297522762","room_confirmation_number":"PB12368527622","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","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":"89224","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-22 13:24:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89224","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":"3001782","reservation_id":"76263","confirmation_number":"PB12264727281","room_confirmation_number":"PB12336729991","room_stay_from":"2019-07-23","room_stay_to":"2019-07-30","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"85912","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-05-11 17:11:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85912","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":"3001854","reservation_id":"78516","confirmation_number":"PB12238607041","room_confirmation_number":"PB12310541522","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"87566","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-12 10:30:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87566","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":"3001884","reservation_id":"80801","confirmation_number":"PB12280254426","room_confirmation_number":"PB12362538268","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88980","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-16 02:00: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":"88980","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":"3001947","reservation_id":"80360","confirmation_number":"PB12239475587","room_confirmation_number":"PB12382904894","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","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":"88667","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-07 19:36:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88667","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":"3007018","reservation_id":"81228","confirmation_number":"PB12257541250","room_confirmation_number":"PB12349443835","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"78978","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-22 21:55:40","reservation_modified_date_time":"2019-08-04 22:21:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78978","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":"3007083","reservation_id":"81153","confirmation_number":"PB12263550900","room_confirmation_number":"PB12399485406","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","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":"89194","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-21 14:33:20","reservation_modified_date_time":"2019-08-04 22:53:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89194","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":"3002266","reservation_id":"81284","confirmation_number":"PB12295992907","room_confirmation_number":"PB12390434137","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 18:24:37","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89295","parentCustTravId":"89295","customer_traveller_id":"89295","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"","canceled_nights_data":"","product_attribute_values":null,"deltaChange":0,"currentDayPrice":40,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002147","reservation_id":"81258","confirmation_number":"PB12238376624","room_confirmation_number":"PB12319834560","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 12:30:58","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88234","parentCustTravId":"88234","customer_traveller_id":"88234","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002152","reservation_id":"81261","confirmation_number":"PB12268796762","room_confirmation_number":"PB12324606953","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 12:52:30","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89275","parentCustTravId":"89275","customer_traveller_id":"89275","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002162","reservation_id":"81264","confirmation_number":"PB12249583764","room_confirmation_number":"PB12395012843","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1217","service_quantity":"4","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 13:02:36","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89278","parentCustTravId":"89278","customer_traveller_id":"89278","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":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002171","reservation_id":"81268","confirmation_number":"PB12272358191","room_confirmation_number":"PB12359397787","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 13:26:08","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89282","parentCustTravId":"89282","customer_traveller_id":"89282","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002275","reservation_id":"81286","confirmation_number":"PB12229864340","room_confirmation_number":"PB12382175519","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 18:42:31","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79486","parentCustTravId":"79486","customer_traveller_id":"79486","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002976","reservation_id":"81261","confirmation_number":"PB12271484601","room_confirmation_number":"PB12326243488","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 12:52:30","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89275","parentCustTravId":"89275","customer_traveller_id":"89275","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002322","reservation_id":"81293","confirmation_number":"PB12270637265","room_confirmation_number":"PB12347368822","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"22.60","product_id":null,"service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 20:41:18","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002372","reservation_id":"81301","confirmation_number":"PB12244154799","room_confirmation_number":"PB12367372737","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.27","grand_total":"3.50","paid_amount":"3.50","product_id":null,"service_quantity":"1","product_name":"SunBlock / Tanning Oil","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 22:58:01","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3002398","reservation_id":"81308","confirmation_number":"PB12246312741","room_confirmation_number":"PB12352238880","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.50","grand_total":"0.50","paid_amount":"0.50","product_id":null,"service_quantity":"1","product_name":"Laundry Soap","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-24 01:06:48","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.50","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"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":3,"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":"2999886","reservation_id":"80928","confirmation_number":"BV12429452239","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.25","nightly_discount":"0","subtotal":"119.25","grand_total":"134.76","paid_amount":"134.76","room_type_id":"307","product_id":"1224","siteminder_id":"BDC-3030379485","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":"89066","customer_id":"89066","source_of_creation":"Booking.com","reservation_created_date":"2019-07-18 05:45:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"17.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.25","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":"3001037","reservation_id":"79758","confirmation_number":"BV12448629009","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"135.91,135.91,135.91,135.91","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"543.64","grand_total":"614.31","paid_amount":"614.31","room_type_id":"308","product_id":"1225","siteminder_id":"BDC-3707722538","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":"88262","customer_id":"88262","source_of_creation":"Booking.com","reservation_created_date":"2019-06-28 01:18:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"93.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"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_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3002315","reservation_id":"81290","confirmation_number":"BV12422337144","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.15","nightly_discount":"0.00","subtotal":"145.15","grand_total":"164.02","paid_amount":"164.02","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":"89300","customer_id":"89300","source_of_creation":"FE","reservation_created_date":"2019-07-23 20:06:55","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":"145.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2994020","reservation_id":"79993","confirmation_number":"BV12442804812","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.84,123.84,123.84,123.84","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"495.36","grand_total":"559.76","paid_amount":"559.76","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88431","customer_id":"88431","source_of_creation":"PMS","reservation_created_date":"2019-07-01 15:41:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.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"}]},{"room_stay_id":"3001585","reservation_id":"80443","confirmation_number":"BV12417079361","room_stay_from":"2019-07-21","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,31.66,0.00","subtotal":"534.00","grand_total":"567.64","paid_amount":"567.64","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88736","customer_id":"88736","source_of_creation":"PMS","reservation_created_date":"2019-07-09 14:52:39","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":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002204","reservation_id":"81240","confirmation_number":"BV12463416878","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.88,99.00","nightly_discount":"7.10,7.10","subtotal":"218.88","grand_total":"231.29","paid_amount":"231.29","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":"89259","customer_id":"89259","source_of_creation":"PMS","reservation_created_date":"2019-07-23 01:02:34","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":"99.00","currentDayDiscount":"7.10","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002217","reservation_id":"81209","confirmation_number":"BV12430246405","room_stay_from":"2019-07-23","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"97.60,97.60","nightly_discount":"0.00,5.98,0.00","subtotal":"195.20","grand_total":"213.82","paid_amount":"213.82","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89237","customer_id":"89237","source_of_creation":"PMS","reservation_created_date":"2019-07-22 17:34:37","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007174","reservation_id":"79546","confirmation_number":"BV12451775235","room_stay_from":"2019-07-23","room_stay_to":"2019-07-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.45,74.45,74.45,97.99,97.99,74.45,74.45,74.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"642.68","grand_total":"726.23","paid_amount":"726.23","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84626","customer_id":"84626","source_of_creation":"PMS","reservation_created_date":"2019-06-25 00:16:39","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2996718","reservation_id":"80443","confirmation_number":"BV12257280054","room_confirmation_number":"BV12417079361","room_stay_from":"2019-07-21","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88736","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-09 14:52:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88736","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":"3001039","reservation_id":"79758","confirmation_number":"BV12272315482","room_confirmation_number":"BV12448629009","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"88262","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-20 20:39:29","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88262","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":"3002215","reservation_id":"81209","confirmation_number":"BV12269711118","room_confirmation_number":"BV12430246405","room_stay_from":"2019-07-23","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"10.00,10.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"89237","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-22 17:34:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89237","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":"2994021","reservation_id":"79993","confirmation_number":"BV12238775371","room_confirmation_number":"BV12442804812","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88431","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-01 15:41:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88431","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":"2999887","reservation_id":"80928","confirmation_number":"BV12212818458","room_confirmation_number":"BV12429452239","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89066","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-18 05:45:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89066","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":"3001040","reservation_id":"79758","confirmation_number":"BV12257620597","room_confirmation_number":"BV12448629009","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","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":"88262","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-28 01:18: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":"88262","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":"3001586","reservation_id":"80443","confirmation_number":"BV12227081504","room_confirmation_number":"BV12417079361","room_stay_from":"2019-07-21","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"88736","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-09 14:52:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88736","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":"3002205","reservation_id":"81240","confirmation_number":"BV12263457069","room_confirmation_number":"BV12463416878","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","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":"89259","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 01:02:34","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89259","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":"3002218","reservation_id":"81209","confirmation_number":"BV12228025726","room_confirmation_number":"BV12430246405","room_stay_from":"2019-07-23","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"89237","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-22 17:34:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89237","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":"3002316","reservation_id":"81290","confirmation_number":"BV12268552143","room_confirmation_number":"BV12422337144","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"89300","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 20:06:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89300","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":"3007175","reservation_id":"79546","confirmation_number":"BV12236250811","room_confirmation_number":"BV12451775235","room_stay_from":"2019-07-23","room_stay_to":"2019-07-31","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":"84626","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-25 00:16:39","reservation_modified_date_time":"2019-08-05 00:06:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84626","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":"3014952","reservation_id":"81272","confirmation_number":"BV12225151771","room_confirmation_number":"BV12422589775","room_stay_from":"2019-09-11","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 14:55:02","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3002259","reservation_id":"81281","confirmation_number":"BV12281656121","room_confirmation_number":"BV12488669443","room_stay_from":"2019-07-27","room_stay_to":"2019-07-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 17:56:03","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89293","parentCustTravId":"89293","customer_traveller_id":"89293","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,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002260","reservation_id":"81281","confirmation_number":"BV12253720453","room_confirmation_number":"BV12488669443","room_stay_from":"2019-07-27","room_stay_to":"2019-07-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 17:56:03","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89293","parentCustTravId":"89293","customer_traveller_id":"89293","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,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":1,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3000103","reservation_id":"80973","confirmation_number":"BP12517986610","room_stay_from":"2019-07-22","room_stay_to":"2019-07-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.27,129.27,129.27,129.27,164.66,164.66,129.27","nightly_discount":"0,0,0,0,0,0,0","subtotal":"975.67","grand_total":"1102.51","paid_amount":"1102.51","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-3445421025","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":"89102","customer_id":"89102","source_of_creation":"Booking.com","reservation_created_date":"2019-07-18 22:26:06","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"146.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007298","reservation_id":"80454","confirmation_number":"BP12535658955","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"71.73,71.73","nightly_discount":"0,0","subtotal":"143.46","grand_total":"162.11","paid_amount":"143.46","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-2589168881","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":"88745","customer_id":"88745","source_of_creation":"Booking.com","reservation_created_date":"2019-07-09 18:58:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"21.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.73","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[{"room_stay_id":"2984208","reservation_id":"77936","confirmation_number":"BP12596742286","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.04,123.04,123.04,123.04","nightly_discount":"0,0,0,0","subtotal":"492.16","grand_total":"492.16","paid_amount":"139.04","room_type_id":"295","product_id":"1129","siteminder_id":"BDC-2814245305","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":"87135","customer_id":"87135","source_of_creation":"Booking.com","reservation_created_date":"2019-06-04 11:31:07","service_canceled_date_time":"2019-07-23 19:08:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"190.18","deltaChange":"16","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"2984210","reservation_id":"77936","confirmation_number":"BP12525393700","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.93,153.93,153.93,153.93","nightly_discount":"0,0,0,0","subtotal":"615.72","grand_total":"615.72","paid_amount":"173.94","room_type_id":"296","product_id":"1130","siteminder_id":"BDC-2814245305","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":"87135","customer_id":"87135","source_of_creation":"Booking.com","reservation_created_date":"2019-06-04 11:31:11","service_canceled_date_time":"2019-07-23 19:08:10","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"190.18","deltaChange":"20.01","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"2996821","reservation_id":"80468","confirmation_number":"BP12566756755","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.81","nightly_discount":"0","subtotal":"90.81","grand_total":"102.62","paid_amount":"102.62","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1296379432","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":"88761","customer_id":"88761","source_of_creation":"Expedia","reservation_created_date":"2019-07-10 00:54:08","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":"90.81","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":"3001706","reservation_id":"80292","confirmation_number":"BP12567102938","room_stay_from":"2019-07-22","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.78,117.78,117.78,117.78,135.02","nightly_discount":"0,0,0,0,0","subtotal":"606.14","grand_total":"684.94","paid_amount":"684.94","room_type_id":"294","product_id":"1126","siteminder_id":"EXP-1293799418","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":"88627","customer_id":"88627","source_of_creation":"Expedia","reservation_created_date":"2019-07-06 15:08:09","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.78","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"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":"3000367","reservation_id":"80510","confirmation_number":"BP12599058744","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"176.90,176.90","nightly_discount":"0.00,0.00","subtotal":"353.80","grand_total":"399.80","paid_amount":"399.80","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":"88787","customer_id":"88787","source_of_creation":"PMS","reservation_created_date":"2019-07-10 23:14:54","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":"176.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3000998","reservation_id":"80518","confirmation_number":"BP12590408273","room_stay_from":"2019-07-20","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"161.00,116.64,116.64,116.64,116.64,116.64,161.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,51.91,0.00","subtotal":"905.20","grand_total":"964.22","paid_amount":"964.22","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"52624","customer_id":"52624","source_of_creation":"PMS","reservation_created_date":"2019-07-11 00:15:21","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"116.64","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001577","reservation_id":"80827","confirmation_number":"BP12578354582","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.08,136.08","nightly_discount":"0.00,0.00","subtotal":"272.16","grand_total":"307.54","paid_amount":"307.54","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89002","customer_id":"89002","source_of_creation":"PMS","reservation_created_date":"2019-07-21 20:26:09","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002356","reservation_id":"80738","confirmation_number":"BP12547994941","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"126.36,126.36,126.36","nightly_discount":"0.00,0.00,0.00","subtotal":"379.08","grand_total":"428.36","paid_amount":"428.36","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":"88927","customer_id":"88927","source_of_creation":"PMS","reservation_created_date":"2019-07-14 20:30:37","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":"126.36","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2997146","reservation_id":"80518","confirmation_number":"BP12246455309","room_confirmation_number":"BP12590408273","room_stay_from":"2019-07-20","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"30,30,30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"210.00","grand_total":"237.30","paid_amount":"237.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"52624","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-11 00:15:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52624","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":"3000368","reservation_id":"80510","confirmation_number":"BP12241716355","room_confirmation_number":"BP12599058744","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"88787","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-19 15:56:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88787","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":"3002357","reservation_id":"80738","confirmation_number":"BP12237808664","room_confirmation_number":"BP12547994941","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"88927","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-23 22:04:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88927","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2996822","reservation_id":"80468","confirmation_number":"BP12259807012","room_confirmation_number":"BP12566756755","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"88761","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-10 00:54:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88761","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":"3000104","reservation_id":"80973","confirmation_number":"BP12256202165","room_confirmation_number":"BP12517986610","room_stay_from":"2019-07-22","room_stay_to":"2019-07-29","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"89102","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-18 22:26:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89102","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":"3000369","reservation_id":"80510","confirmation_number":"BP12279611572","room_confirmation_number":"BP12599058744","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","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":"88787","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-10 23:14:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88787","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":"3000999","reservation_id":"80518","confirmation_number":"BP12255891853","room_confirmation_number":"BP12590408273","room_stay_from":"2019-07-20","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"52624","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-11 00:15:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52624","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":"3001578","reservation_id":"80827","confirmation_number":"BP12260797837","room_confirmation_number":"BP12578354582","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","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":"89002","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-21 20:26:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89002","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":"3001707","reservation_id":"80292","confirmation_number":"BP12212940960","room_confirmation_number":"BP12567102938","room_stay_from":"2019-07-22","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88627","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-06 15:08: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":"88627","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":"3002358","reservation_id":"80738","confirmation_number":"BP12262273506","room_confirmation_number":"BP12547994941","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"88927","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-14 20:30:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88927","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":"3007299","reservation_id":"80454","confirmation_number":"BP12251580020","room_confirmation_number":"BP12535658955","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"0.00,20.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88745","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-09 18:58:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88745","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":"3006731","reservation_id":"81273","confirmation_number":"BP12241208454","room_confirmation_number":"BP12565370859","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","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":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"89286","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-23 15:02:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89286","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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"}]}],"resort_fee_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-07-23","total_rooms_exist":66,"departureCount":16,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"1","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2991146","reservation_id":"79442","confirmation_number":"PB12367880216","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.39,173.39,173.39","nightly_discount":"0,0,0","subtotal":"520.17","grand_total":"587.79","paid_amount":"587.79","room_type_id":"289","product_id":"1105","siteminder_id":"BDC-3203474843","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":"88022","customer_id":"88022","source_of_creation":"Booking.com","reservation_created_date":"2019-06-23 01:24:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"87.03","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.39","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":"2999886","reservation_id":"80928","confirmation_number":"BV12429452239","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.25","nightly_discount":"0","subtotal":"119.25","grand_total":"134.76","paid_amount":"134.76","room_type_id":"307","product_id":"1224","siteminder_id":"BDC-3030379485","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":"89066","customer_id":"89066","source_of_creation":"Booking.com","reservation_created_date":"2019-07-18 05:45:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"17.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.25","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":"3000103","reservation_id":"80973","confirmation_number":"BP12517986610","room_stay_from":"2019-07-22","room_stay_to":"2019-07-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.27,129.27,129.27,129.27,164.66,164.66,129.27","nightly_discount":"0,0,0,0,0,0,0","subtotal":"975.67","grand_total":"1102.51","paid_amount":"1102.51","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-3445421025","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":"89102","customer_id":"89102","source_of_creation":"Booking.com","reservation_created_date":"2019-07-18 22:26:06","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"146.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001037","reservation_id":"79758","confirmation_number":"BV12448629009","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"135.91,135.91,135.91,135.91","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"543.64","grand_total":"614.31","paid_amount":"614.31","room_type_id":"308","product_id":"1225","siteminder_id":"BDC-3707722538","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":"88262","customer_id":"88262","source_of_creation":"Booking.com","reservation_created_date":"2019-06-28 01:18:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"93.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001780","reservation_id":"76263","confirmation_number":"PB12336729991","room_stay_from":"2019-07-23","room_stay_to":"2019-07-30","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"160.25,160.25,160.25,163.41,163.41,160.25,160.25","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1128.07","grand_total":"1274.71","paid_amount":"1274.71","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3116089608","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"210.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85912","customer_id":"85912","source_of_creation":"Booking.com","reservation_created_date":"2019-05-11 17:11:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"200.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.25","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":"3007298","reservation_id":"80454","confirmation_number":"BP12535658955","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"71.73,71.73","nightly_discount":"0,0","subtotal":"143.46","grand_total":"162.11","paid_amount":"143.46","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-2589168881","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":"88745","customer_id":"88745","source_of_creation":"Booking.com","reservation_created_date":"2019-07-09 18:58:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"21.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.73","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[{"room_stay_id":"2919390","reservation_id":"67181","confirmation_number":"PB12368490960","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"25.20,25.20,25.20,25.20","nightly_discount":"0,0,0,0","subtotal":"100.80","grand_total":"100.80","paid_amount":"28.48","room_type_id":"288","product_id":"1091","siteminder_id":"BDC-1890164028","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80507","customer_id":"80507","source_of_creation":"Booking.com","reservation_created_date":"2019-01-18 18:39:12","service_canceled_date_time":"2019-07-23 18:42:51","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"15.12","deltaChange":"3.28","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"2984208","reservation_id":"77936","confirmation_number":"BP12596742286","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.04,123.04,123.04,123.04","nightly_discount":"0,0,0,0","subtotal":"492.16","grand_total":"492.16","paid_amount":"139.04","room_type_id":"295","product_id":"1129","siteminder_id":"BDC-2814245305","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":"87135","customer_id":"87135","source_of_creation":"Booking.com","reservation_created_date":"2019-06-04 11:31:07","service_canceled_date_time":"2019-07-23 19:08:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"190.18","deltaChange":"16","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"2984210","reservation_id":"77936","confirmation_number":"BP12525393700","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.93,153.93,153.93,153.93","nightly_discount":"0,0,0,0","subtotal":"615.72","grand_total":"615.72","paid_amount":"173.94","room_type_id":"296","product_id":"1130","siteminder_id":"BDC-2814245305","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":"87135","customer_id":"87135","source_of_creation":"Booking.com","reservation_created_date":"2019-06-04 11:31:11","service_canceled_date_time":"2019-07-23 19:08:10","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"190.18","deltaChange":"20.01","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"2989615","reservation_id":"78939","confirmation_number":"PB12336030473","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"131,131,131,131","nightly_discount":"0,0,0,0","subtotal":"524.00","grand_total":"592.12","paid_amount":"592.12","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1281052291","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87864","customer_id":"87864","source_of_creation":"Expedia","reservation_created_date":"2019-06-19 00:40:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131","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":"2991779","reservation_id":"79570","confirmation_number":"PB12321386863","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"136,136,136,136","nightly_discount":"0,0,0,0","subtotal":"544.00","grand_total":"614.72","paid_amount":"614.72","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1285733643","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88122","customer_id":"88122","source_of_creation":"Expedia","reservation_created_date":"2019-06-25 16:04:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136","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":"2991782","reservation_id":"79571","confirmation_number":"PB12375406445","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"4","nightly_price":"131,131,131,131","nightly_discount":"0,0,0,0","subtotal":"524.00","grand_total":"592.12","paid_amount":"592.12","room_type_id":"289","product_id":"1121","siteminder_id":"EXP-1285733644","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88123","customer_id":"88123","source_of_creation":"Expedia","reservation_created_date":"2019-06-25 16:04:14","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":"131","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":"2992948","reservation_id":"79797","confirmation_number":"PB12348374270","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.77,155.77,155.77","nightly_discount":"0,0,0","subtotal":"467.31","grand_total":"528.06","paid_amount":"528.06","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1288159671","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":"88293","customer_id":"88293","source_of_creation":"Expedia","reservation_created_date":"2019-06-28 18:44:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"155.77","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":"2996821","reservation_id":"80468","confirmation_number":"BP12566756755","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.81","nightly_discount":"0","subtotal":"90.81","grand_total":"102.62","paid_amount":"102.62","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1296379432","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":"88761","customer_id":"88761","source_of_creation":"Expedia","reservation_created_date":"2019-07-10 00:54:08","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":"90.81","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":"2999544","reservation_id":"80862","confirmation_number":"PB12345354449","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"120.97","nightly_discount":"0","subtotal":"120.97","grand_total":"136.70","paid_amount":"136.70","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1302040960","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89028","customer_id":"89028","source_of_creation":"Expedia","reservation_created_date":"2019-07-17 16:10:11","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":"120.97","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":"2999996","reservation_id":"78604","confirmation_number":"PB12372532499","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"91.15,88.82,88.82,88.82,88.82,88.82","nightly_discount":"0,0,0,0,0,0","subtotal":"535.25","grand_total":"604.84","paid_amount":"604.84","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1277256062","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"180.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87629","customer_id":"87629","source_of_creation":"Expedia","reservation_created_date":"2019-06-13 14:15:06","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":"88.82","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":"3001706","reservation_id":"80292","confirmation_number":"BP12567102938","room_stay_from":"2019-07-22","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.78,117.78,117.78,117.78,135.02","nightly_discount":"0,0,0,0,0","subtotal":"606.14","grand_total":"684.94","paid_amount":"684.94","room_type_id":"294","product_id":"1126","siteminder_id":"EXP-1293799418","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":"88627","customer_id":"88627","source_of_creation":"Expedia","reservation_created_date":"2019-07-06 15:08:09","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.78","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":"3001883","reservation_id":"80801","confirmation_number":"PB12362538268","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.02,132.02,132.02","nightly_discount":"0.00,0.00,0.00","subtotal":"396.06","grand_total":"447.54","paid_amount":"447.54","room_type_id":"289","product_id":"1099","siteminder_id":"EXP-1300742833","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":"88980","customer_id":"88980","source_of_creation":"Expedia","reservation_created_date":"2019-07-16 02:00:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2994789","reservation_id":"80085","confirmation_number":"PB12351339452","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.03","nightly_discount":"0","subtotal":"70.03","grand_total":"79.13","paid_amount":"79.13","room_type_id":"285","product_id":"1083","siteminder_id":"HTN-90233476-CP3T6P","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":"88507","customer_id":"88507","source_of_creation":"HotelTonight","reservation_created_date":"2019-07-03 07:21:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.03","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":"2994791","reservation_id":"80086","confirmation_number":"PB12390471328","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.02,49.02,49.02","nightly_discount":"0,0,0","subtotal":"147.06","grand_total":"166.17","paid_amount":"166.17","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-90235675-LREZG3","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":"88508","customer_id":"88508","source_of_creation":"HotelTonight","reservation_created_date":"2019-07-03 08:20:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001587","reservation_id":"79496","confirmation_number":"PB12321867331","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.69,49.02,49.02","nightly_discount":"0,0,0","subtotal":"162.73","grand_total":"183.88","paid_amount":"183.88","room_type_id":"289","product_id":"1098","siteminder_id":"HTN-89185316-PDLCVW","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":"88063","customer_id":"88063","source_of_creation":"HotelTonight","reservation_created_date":"2019-06-24 02:47:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2989031","reservation_id":"78832","confirmation_number":"PB12372442856","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"215.46,215.46,215.46,215.46","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"861.84","grand_total":"973.88","paid_amount":"973.88","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":"87781","customer_id":"87781","source_of_creation":"FE","reservation_created_date":"2019-06-17 13:53:57","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":"215.46","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002315","reservation_id":"81290","confirmation_number":"BV12422337144","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.15","nightly_discount":"0.00","subtotal":"145.15","grand_total":"164.02","paid_amount":"164.02","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":"89300","customer_id":"89300","source_of_creation":"FE","reservation_created_date":"2019-07-23 20:06:55","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":"145.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2937847","reservation_id":"58744","confirmation_number":"PB12395907853","room_stay_from":"2019-07-23","room_stay_to":"2019-08-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.00,162.00,162.00,162.00,162.00,162.00,162.00,162.00,162.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1458.00","grand_total":"1647.54","paid_amount":"1647.54","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":"26574","customer_id":"26574","source_of_creation":"PMS","reservation_created_date":"2018-10-23 14:18:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"162.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2979309","reservation_id":"77013","confirmation_number":"PB12347861077","room_stay_from":"2019-07-21","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"188.73,188.73,188.73,188.73,188.73","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"943.65","grand_total":"1066.33","paid_amount":"1066.33","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":"86487","customer_id":"86487","source_of_creation":"PMS","reservation_created_date":"2019-05-21 14:02:16","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2994020","reservation_id":"79993","confirmation_number":"BV12442804812","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.84,123.84,123.84,123.84","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"495.36","grand_total":"559.76","paid_amount":"559.76","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88431","customer_id":"88431","source_of_creation":"PMS","reservation_created_date":"2019-07-01 15:41:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.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"}]},{"room_stay_id":"2995512","reservation_id":"80243","confirmation_number":"PB12332610881","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","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":"88609","customer_id":"88609","source_of_creation":"PMS","reservation_created_date":"2019-07-05 21:03:40","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2995515","reservation_id":"80244","confirmation_number":"PB12371425668","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","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":"88609","customer_id":"88609","source_of_creation":"PMS","reservation_created_date":"2019-07-05 21:05:43","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":"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":"2995522","reservation_id":"80246","confirmation_number":"PB12332282682","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88609","customer_id":"88609","source_of_creation":"PMS","reservation_created_date":"2019-07-05 21:07:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2995525","reservation_id":"80247","confirmation_number":"PB12325928071","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"291","product_id":"1115","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88609","customer_id":"88609","source_of_creation":"PMS","reservation_created_date":"2019-07-05 21:08:54","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":"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":"2998336","reservation_id":"51651","confirmation_number":"PB12336577623","room_stay_from":"2019-07-13","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.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,106.60,0.00","subtotal":"2296.00","grand_total":"2474.02","paid_amount":"2474.02","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"27447","customer_id":"27447","source_of_creation":"PMS","reservation_created_date":"2018-07-21 15:14:40","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":"164.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2998340","reservation_id":"68024","confirmation_number":"PB12395019515","room_stay_from":"2019-07-13","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.00,164.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,106.60,0.00","subtotal":"2296.00","grand_total":"2474.02","paid_amount":"2474.02","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"27447","customer_id":"27447","source_of_creation":"PMS","reservation_created_date":"2019-01-28 17:10:19","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":"164.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3000367","reservation_id":"80510","confirmation_number":"BP12599058744","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"176.90,176.90","nightly_discount":"0.00,0.00","subtotal":"353.80","grand_total":"399.80","paid_amount":"399.80","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":"88787","customer_id":"88787","source_of_creation":"PMS","reservation_created_date":"2019-07-10 23:14:54","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":"176.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3000998","reservation_id":"80518","confirmation_number":"BP12590408273","room_stay_from":"2019-07-20","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"161.00,116.64,116.64,116.64,116.64,116.64,161.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,51.91,0.00","subtotal":"905.20","grand_total":"964.22","paid_amount":"964.22","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"52624","customer_id":"52624","source_of_creation":"PMS","reservation_created_date":"2019-07-11 00:15:21","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"116.64","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001394","reservation_id":"78093","confirmation_number":"PB12359932233","room_stay_from":"2019-07-22","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.61,146.61,146.61","nightly_discount":"0.00,0.00,0.00","subtotal":"439.83","grand_total":"497.01","paid_amount":"497.01","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"42869","customer_id":"42869","source_of_creation":"PMS","reservation_created_date":"2019-06-06 01:32:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"146.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001577","reservation_id":"80827","confirmation_number":"BP12578354582","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.08,136.08","nightly_discount":"0.00,0.00","subtotal":"272.16","grand_total":"307.54","paid_amount":"307.54","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89002","customer_id":"89002","source_of_creation":"PMS","reservation_created_date":"2019-07-21 20:26:09","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001585","reservation_id":"80443","confirmation_number":"BV12417079361","room_stay_from":"2019-07-21","room_stay_to":"2019-07-27","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,31.66,0.00","subtotal":"534.00","grand_total":"567.64","paid_amount":"567.64","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88736","customer_id":"88736","source_of_creation":"PMS","reservation_created_date":"2019-07-09 14:52:39","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":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001681","reservation_id":"81012","confirmation_number":"PB12358676975","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.61,146.61,146.61,146.61","nightly_discount":"0.00,0.00,0.00,24.38,0.00","subtotal":"586.44","grand_total":"635.12","paid_amount":"635.12","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":"89127","customer_id":"89127","source_of_creation":"PMS","reservation_created_date":"2019-07-19 15:04:55","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":"146.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001689","reservation_id":"81191","confirmation_number":"PB12368527622","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00","nightly_discount":"0.00,0.00","subtotal":"220.00","grand_total":"248.60","paid_amount":"248.60","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":"89224","customer_id":"89224","source_of_creation":"PMS","reservation_created_date":"2019-07-22 13:24:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001853","reservation_id":"78516","confirmation_number":"PB12310541522","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00","nightly_discount":"0.00,0.00,5.43,0.00","subtotal":"477.00","grand_total":"532.87","paid_amount":"532.87","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":"87566","customer_id":"87566","source_of_creation":"PMS","reservation_created_date":"2019-06-12 10:30:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.00","currentDayDiscount":"5.43","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3001945","reservation_id":"80360","confirmation_number":"PB12382904894","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"146.61,146.61,146.61,146.61","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"586.44","grand_total":"662.68","paid_amount":"662.68","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":"88667","customer_id":"88667","source_of_creation":"PMS","reservation_created_date":"2019-07-07 19:36:48","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"146.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002204","reservation_id":"81240","confirmation_number":"BV12463416878","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.88,99.00","nightly_discount":"7.10,7.10","subtotal":"218.88","grand_total":"231.29","paid_amount":"231.29","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":"89259","customer_id":"89259","source_of_creation":"PMS","reservation_created_date":"2019-07-23 01:02:34","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":"99.00","currentDayDiscount":"7.10","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002217","reservation_id":"81209","confirmation_number":"BV12430246405","room_stay_from":"2019-07-23","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"97.60,97.60","nightly_discount":"0.00,5.98,0.00","subtotal":"195.20","grand_total":"213.82","paid_amount":"213.82","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89237","customer_id":"89237","source_of_creation":"PMS","reservation_created_date":"2019-07-22 17:34:37","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002356","reservation_id":"80738","confirmation_number":"BP12547994941","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"126.36,126.36,126.36","nightly_discount":"0.00,0.00,0.00","subtotal":"379.08","grand_total":"428.36","paid_amount":"428.36","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":"88927","customer_id":"88927","source_of_creation":"PMS","reservation_created_date":"2019-07-14 20:30:37","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":"126.36","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007017","reservation_id":"81228","confirmation_number":"PB12349443835","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.95,90.95,90.95","nightly_discount":"0.00,0.00,0.00","subtotal":"272.85","grand_total":"308.32","paid_amount":"308.32","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":"78978","customer_id":"78978","source_of_creation":"PMS","reservation_created_date":"2019-07-22 21:55:40","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":"90.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007050","reservation_id":"81261","confirmation_number":"PB12324606953","room_stay_from":"2019-07-23","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.95,90.95","nightly_discount":"0.00,0.00","subtotal":"181.90","grand_total":"205.54","paid_amount":"205.54","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":"89275","customer_id":"89275","source_of_creation":"PMS","reservation_created_date":"2019-07-23 12:52:30","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007082","reservation_id":"81153","confirmation_number":"PB12399485406","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"112.11,112.11,112.10,112.10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"448.42","grand_total":"506.72","paid_amount":"506.72","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":"89194","customer_id":"89194","source_of_creation":"PMS","reservation_created_date":"2019-07-21 14:33:20","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":"112.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007174","reservation_id":"79546","confirmation_number":"BV12451775235","room_stay_from":"2019-07-23","room_stay_to":"2019-07-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.45,74.45,74.45,97.99,97.99,74.45,74.45,74.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"642.68","grand_total":"726.23","paid_amount":"726.23","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84626","customer_id":"84626","source_of_creation":"PMS","reservation_created_date":"2019-06-25 00:16:39","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2979310","reservation_id":"77013","confirmation_number":"PB12224609211","room_confirmation_number":"PB12347861077","room_stay_from":"2019-07-21","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"86487","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-05-21 14:02:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86487","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":"2989033","reservation_id":"78832","confirmation_number":"PB12266130827","room_confirmation_number":"PB12372442856","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"87781","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-17 13:53:57","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87781","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":"2989616","reservation_id":"78939","confirmation_number":"PB12236422723","room_confirmation_number":"PB12336030473","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"87864","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-19 00:40:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87864","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":"2991780","reservation_id":"79570","confirmation_number":"PB12283584875","room_confirmation_number":"PB12321386863","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"88122","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-25 16:04: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":"88122","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2991783","reservation_id":"79571","confirmation_number":"PB12276576364","room_confirmation_number":"PB12375406445","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"88123","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-25 16:04:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88123","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":"2995514","reservation_id":"80243","confirmation_number":"PB12227536033","room_confirmation_number":"PB12332610881","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-05 21:03:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995516","reservation_id":"80244","confirmation_number":"PB12238213540","room_confirmation_number":"PB12371425668","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-05 21:05:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995523","reservation_id":"80246","confirmation_number":"PB12293809512","room_confirmation_number":"PB12332282682","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-05 21:07:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995526","reservation_id":"80247","confirmation_number":"PB12297469592","room_confirmation_number":"PB12325928071","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-05 21:08:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2996317","reservation_id":"78516","confirmation_number":"PB12297519041","room_confirmation_number":"PB12310541522","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"87566","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-07 23:28:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87566","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2996718","reservation_id":"80443","confirmation_number":"BV12257280054","room_confirmation_number":"BV12417079361","room_stay_from":"2019-07-21","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88736","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-09 14:52:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88736","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":"2997146","reservation_id":"80518","confirmation_number":"BP12246455309","room_confirmation_number":"BP12590408273","room_stay_from":"2019-07-20","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"30,30,30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"210.00","grand_total":"237.30","paid_amount":"237.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"52624","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-11 00:15:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52624","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":"2999545","reservation_id":"80862","confirmation_number":"PB12243914273","room_confirmation_number":"PB12345354449","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"89028","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-17 16:10: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":"89028","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":"2999997","reservation_id":"78604","confirmation_number":"PB12265972187","room_confirmation_number":"PB12372532499","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"30,30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"87629","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-18 16:38:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87629","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":"3000368","reservation_id":"80510","confirmation_number":"BP12241716355","room_confirmation_number":"BP12599058744","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"88787","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-19 15:56:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88787","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":"3001039","reservation_id":"79758","confirmation_number":"BV12272315482","room_confirmation_number":"BV12448629009","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"88262","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-20 20:39:29","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88262","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":"3001569","reservation_id":"81153","confirmation_number":"PB12238015757","room_confirmation_number":"PB12399485406","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"89194","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-21 20:05:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89194","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":"3001781","reservation_id":"76263","confirmation_number":"PB12240279710","room_confirmation_number":"PB12336729991","room_stay_from":"2019-07-23","room_stay_to":"2019-07-30","room_stay_status":"Active","nightly_price":"30,30,30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"210.00","grand_total":"237.30","paid_amount":"237.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"85912","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-22 15:02:38","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85912","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":"3001946","reservation_id":"80360","confirmation_number":"PB12258316312","room_confirmation_number":"PB12382904894","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"88667","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-22 18:44:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88667","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":"3002215","reservation_id":"81209","confirmation_number":"BV12269711118","room_confirmation_number":"BV12430246405","room_stay_from":"2019-07-23","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"10.00,10.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"89237","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-22 17:34:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89237","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":"3002357","reservation_id":"80738","confirmation_number":"BP12237808664","room_confirmation_number":"BP12547994941","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"88927","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-07-23 22:04:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88927","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2937848","reservation_id":"58744","confirmation_number":"PB12330456223","room_confirmation_number":"PB12395907853","room_stay_from":"2019-07-23","room_stay_to":"2019-08-01","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0.00,0.00","nightly_discount":"0,0,0,0,0,0,0,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26574","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-10-26 19:54:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26574","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":"2979311","reservation_id":"77013","confirmation_number":"PB12286426384","room_confirmation_number":"PB12347861077","room_stay_from":"2019-07-21","room_stay_to":"2019-07-26","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":"86487","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-21 14:02:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86487","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":"2989032","reservation_id":"78832","confirmation_number":"PB12243086088","room_confirmation_number":"PB12372442856","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","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":"87781","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-17 13:53:57","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87781","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":"2989617","reservation_id":"78939","confirmation_number":"PB12271664976","room_confirmation_number":"PB12336030473","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"87864","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-19 00:40:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87864","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":"2991147","reservation_id":"79442","confirmation_number":"PB12232292478","room_confirmation_number":"PB12367880216","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88022","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-23 01:24:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88022","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":"2991781","reservation_id":"79570","confirmation_number":"PB12263320602","room_confirmation_number":"PB12321386863","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"88122","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-25 16:04: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":"88122","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":"2991784","reservation_id":"79571","confirmation_number":"PB12252169708","room_confirmation_number":"PB12375406445","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"88123","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-25 16:04:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88123","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":"2992949","reservation_id":"79797","confirmation_number":"PB12215397054","room_confirmation_number":"PB12348374270","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88293","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-28 18:44: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":"88293","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":"2994021","reservation_id":"79993","confirmation_number":"BV12238775371","room_confirmation_number":"BV12442804812","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88431","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-01 15:41:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88431","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":"2994790","reservation_id":"80085","confirmation_number":"PB12234500399","room_confirmation_number":"PB12351339452","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"88507","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-03 07:21: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":"88507","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":"2994792","reservation_id":"80086","confirmation_number":"PB12273030021","room_confirmation_number":"PB12390471328","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88508","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-03 08:20:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88508","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":"2995513","reservation_id":"80243","confirmation_number":"PB12216314542","room_confirmation_number":"PB12332610881","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-05 21:03:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995517","reservation_id":"80244","confirmation_number":"PB12228504926","room_confirmation_number":"PB12371425668","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-05 21:05:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995524","reservation_id":"80246","confirmation_number":"PB12298792157","room_confirmation_number":"PB12332282682","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-05 21:07:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2995527","reservation_id":"80247","confirmation_number":"PB12266967846","room_confirmation_number":"PB12325928071","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-05 21:08:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88609","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":"2996822","reservation_id":"80468","confirmation_number":"BP12259807012","room_confirmation_number":"BP12566756755","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"88761","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-10 00:54:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88761","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":"2998337","reservation_id":"51651","confirmation_number":"PBR12216653796","room_confirmation_number":"PB12336577623","room_stay_from":"2019-07-13","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27447","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":"27447","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":"2998341","reservation_id":"68024","confirmation_number":"PB12221648779","room_confirmation_number":"PB12395019515","room_stay_from":"2019-07-13","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27447","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-28 17:10:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27447","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":"2999546","reservation_id":"80862","confirmation_number":"PB12284149794","room_confirmation_number":"PB12345354449","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89028","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-17 16:10: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":"89028","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":"2999887","reservation_id":"80928","confirmation_number":"BV12212818458","room_confirmation_number":"BV12429452239","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89066","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-18 05:45:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89066","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":"2999998","reservation_id":"78604","confirmation_number":"PB12244248829","room_confirmation_number":"PB12372532499","room_stay_from":"2019-07-20","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87629","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-13 14:15: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":"87629","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":"3000104","reservation_id":"80973","confirmation_number":"BP12256202165","room_confirmation_number":"BP12517986610","room_stay_from":"2019-07-22","room_stay_to":"2019-07-29","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"89102","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-18 22:26:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89102","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":"3000369","reservation_id":"80510","confirmation_number":"BP12279611572","room_confirmation_number":"BP12599058744","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","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":"88787","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-10 23:14:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88787","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":"3000999","reservation_id":"80518","confirmation_number":"BP12255891853","room_confirmation_number":"BP12590408273","room_stay_from":"2019-07-20","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"52624","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-11 00:15:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52624","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":"3001040","reservation_id":"79758","confirmation_number":"BV12257620597","room_confirmation_number":"BV12448629009","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","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":"88262","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-28 01:18: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":"88262","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":"3001395","reservation_id":"78093","confirmation_number":"PB12261600301","room_confirmation_number":"PB12359932233","room_stay_from":"2019-07-22","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"42869","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-06 01:32:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42869","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":"3001578","reservation_id":"80827","confirmation_number":"BP12260797837","room_confirmation_number":"BP12578354582","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","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":"89002","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-21 20:26:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89002","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":"3001586","reservation_id":"80443","confirmation_number":"BV12227081504","room_confirmation_number":"BV12417079361","room_stay_from":"2019-07-21","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"88736","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-09 14:52:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88736","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":"3001588","reservation_id":"79496","confirmation_number":"PB12219378912","room_confirmation_number":"PB12321867331","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88063","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-24 02:47:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88063","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":"3001682","reservation_id":"81012","confirmation_number":"PB12258647169","room_confirmation_number":"PB12358676975","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","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":"89127","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-19 15:04:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89127","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":"3001690","reservation_id":"81191","confirmation_number":"PB12297522762","room_confirmation_number":"PB12368527622","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","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":"89224","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-22 13:24:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89224","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":"3001707","reservation_id":"80292","confirmation_number":"BP12212940960","room_confirmation_number":"BP12567102938","room_stay_from":"2019-07-22","room_stay_to":"2019-07-27","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88627","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-06 15:08: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":"88627","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":"3001782","reservation_id":"76263","confirmation_number":"PB12264727281","room_confirmation_number":"PB12336729991","room_stay_from":"2019-07-23","room_stay_to":"2019-07-30","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"85912","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-05-11 17:11:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85912","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":"3001854","reservation_id":"78516","confirmation_number":"PB12238607041","room_confirmation_number":"PB12310541522","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"87566","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-12 10:30:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87566","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":"3001884","reservation_id":"80801","confirmation_number":"PB12280254426","room_confirmation_number":"PB12362538268","room_stay_from":"2019-07-21","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88980","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-16 02:00: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":"88980","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":"3001947","reservation_id":"80360","confirmation_number":"PB12239475587","room_confirmation_number":"PB12382904894","room_stay_from":"2019-07-22","room_stay_to":"2019-07-26","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":"88667","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-07 19:36:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88667","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":"3002205","reservation_id":"81240","confirmation_number":"BV12263457069","room_confirmation_number":"BV12463416878","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","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":"89259","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 01:02:34","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89259","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":"3002218","reservation_id":"81209","confirmation_number":"BV12228025726","room_confirmation_number":"BV12430246405","room_stay_from":"2019-07-23","room_stay_to":"2019-07-25","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"89237","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-22 17:34:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89237","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":"3002316","reservation_id":"81290","confirmation_number":"BV12268552143","room_confirmation_number":"BV12422337144","room_stay_from":"2019-07-23","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"89300","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 20:06:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89300","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":"3002358","reservation_id":"80738","confirmation_number":"BP12262273506","room_confirmation_number":"BP12547994941","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"88927","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-14 20:30:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88927","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":"3007018","reservation_id":"81228","confirmation_number":"PB12257541250","room_confirmation_number":"PB12349443835","room_stay_from":"2019-07-23","room_stay_to":"2019-07-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"78978","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-22 21:55:40","reservation_modified_date_time":"2019-08-04 22:21:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78978","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":"3007083","reservation_id":"81153","confirmation_number":"PB12263550900","room_confirmation_number":"PB12399485406","room_stay_from":"2019-07-21","room_stay_to":"2019-07-25","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":"89194","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-21 14:33:20","reservation_modified_date_time":"2019-08-04 22:53:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89194","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":"3007175","reservation_id":"79546","confirmation_number":"BV12236250811","room_confirmation_number":"BV12451775235","room_stay_from":"2019-07-23","room_stay_to":"2019-07-31","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":"84626","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-25 00:16:39","reservation_modified_date_time":"2019-08-05 00:06:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84626","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":"3007299","reservation_id":"80454","confirmation_number":"BP12251580020","room_confirmation_number":"BP12535658955","room_stay_from":"2019-07-22","room_stay_to":"2019-07-24","room_stay_status":"Active","nightly_price":"0.00,20.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88745","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-09 18:58:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88745","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":"3006731","reservation_id":"81273","confirmation_number":"BP12241208454","room_confirmation_number":"BP12565370859","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","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":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"89286","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-23 15:02:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89286","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"3014952","reservation_id":"81272","confirmation_number":"BV12225151771","room_confirmation_number":"BV12422589775","room_stay_from":"2019-09-11","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-23 14:55:02","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3002147","reservation_id":"81258","confirmation_number":"PB12238376624","room_confirmation_number":"PB12319834560","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 12:30:58","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88234","parentCustTravId":"88234","customer_traveller_id":"88234","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002152","reservation_id":"81261","confirmation_number":"PB12268796762","room_confirmation_number":"PB12324606953","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 12:52:30","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89275","parentCustTravId":"89275","customer_traveller_id":"89275","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002162","reservation_id":"81264","confirmation_number":"PB12249583764","room_confirmation_number":"PB12395012843","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1217","service_quantity":"4","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 13:02:36","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89278","parentCustTravId":"89278","customer_traveller_id":"89278","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":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002171","reservation_id":"81268","confirmation_number":"PB12272358191","room_confirmation_number":"PB12359397787","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 13:26:08","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89282","parentCustTravId":"89282","customer_traveller_id":"89282","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002259","reservation_id":"81281","confirmation_number":"BV12281656121","room_confirmation_number":"BV12488669443","room_stay_from":"2019-07-27","room_stay_to":"2019-07-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 17:56:03","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89293","parentCustTravId":"89293","customer_traveller_id":"89293","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,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002260","reservation_id":"81281","confirmation_number":"BV12253720453","room_confirmation_number":"BV12488669443","room_stay_from":"2019-07-27","room_stay_to":"2019-07-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 17:56:03","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89293","parentCustTravId":"89293","customer_traveller_id":"89293","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,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002275","reservation_id":"81286","confirmation_number":"PB12229864340","room_confirmation_number":"PB12382175519","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 18:42:31","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79486","parentCustTravId":"79486","customer_traveller_id":"79486","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002976","reservation_id":"81261","confirmation_number":"PB12271484601","room_confirmation_number":"PB12326243488","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 12:52:30","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89275","parentCustTravId":"89275","customer_traveller_id":"89275","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002322","reservation_id":"81293","confirmation_number":"PB12270637265","room_confirmation_number":"PB12347368822","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"22.60","product_id":null,"service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 20:41:18","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3002372","reservation_id":"81301","confirmation_number":"PB12244154799","room_confirmation_number":"PB12367372737","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.27","grand_total":"3.50","paid_amount":"3.50","product_id":null,"service_quantity":"1","product_name":"SunBlock / Tanning Oil","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 22:58:01","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3002398","reservation_id":"81308","confirmation_number":"PB12246312741","room_confirmation_number":"PB12352238880","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.50","grand_total":"0.50","paid_amount":"0.50","product_id":null,"service_quantity":"1","product_name":"Laundry Soap","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-24 01:06:48","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.50","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3002266","reservation_id":"81284","confirmation_number":"PB12295992907","room_confirmation_number":"PB12390434137","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-23 18:24:37","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"89295","parentCustTravId":"89295","customer_traveller_id":"89295","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"","canceled_nights_data":"","product_attribute_values":null,"deltaChange":0,"currentDayPrice":40,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}