Naming Columns

Lawson products use the hyphen (-) to separate words in column names (for example, MONTH-PTS). Microsoft SQL Server does not allow hyphens, so the database driver automatically replaces the hyphens with underscores when it communicates with the database. For example, the column MONTH-PTS changes to MONTH_PTS.

Reserved Words

Quoted identifiers eliminate prefixing names with R_. For example, you can now have a column named SELECT, and it will appear as "SELECT" instead of R_SELECT.