Data in Sage but not showing in BI or SQL


I was running a view in both BI and SQL for all customers who are tax exempt for company CEN.. when I run both views in BI and SQL I find that there is no data showing up in the TaxExemptno columns  however when I check some of the customers in Customer Maintenance I find many have data enter into that field..