How SQL Database / Table & Field Name Changed When we Use Some Special Character in NAV?

Hi All,

One of my NAV Friend while working on SSRS Reports asked a Question. Below is the Query is his words?

"Hey Saurav - When i trying to access table Sales Prepayment % or Field Prepayment % or using a database Named as Demo Database NAV (7-0) i get a different name is SQL instead of Navision. Why there is a change? Which all character get changed? Where i can find this change Character List?" 

So those who Know this, i guess what is below is nothing new for you, but those who still are curious about it should Read Ahead...


Read Complete Article »