Mastering SQL Queries for SAP Business One

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "Although, you could link any fields between tables, if the field is not NULL, you should try to use key link wherever possible."

A block of code is set as follows:

DECLARE @Factor as numeric(1,0)

SELECT @Factor = 
CASE (SELECT TOP 1 DispPosDeb FROM OADM)
 WHEN 'N' THEN 1 ELSE -1
END

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Under Select, three fields are selected from two tables".

Note

Warnings or important ...