Options

NAV 2013 SQL table structure changes

aavioaavio Member Posts: 143
edited 2014-09-07 in NAV Three Tier
Noted that in NAV 2013 all %(percentage) field representation changed to _(underscore) in SQL level

In NAV 2009
item table field - in NAV Profit %, in SQL also same as Profit %

In NAV 2013
item table field - in NAV Profit %, in SQL Profit _

may i know why all % changed to _ in NAV 2013?
aav!o

Comments

  • Options
    aavioaavio Member Posts: 143
    i found it where

    msdn.microsoft.com/en-us/library/hh167834(v=nav.71).aspx

    choose Database, choose Alter, and then choose the Integration tab

    Convert Identifiers
    in nav 2009 have only - ."\/'
    in nav 2013 - ."\/'%][

    but why in NAV 2013 have to convert %?
    aav!o
Sign In or Register to comment.