Sales Configuration > Rule Tables
  PPT
Rule Tables
With a rule table you can define rules in a different, sometimes easier way. For example, the rules are simple, but there are many different combinations of the options. By selecting some variables and filling in a rule table, you can let QAD Configurator automatically create a number of IF...THEN... rules for you.
Note: In a rule table, rules do not contain ELSE clauses.
Rule tables can be either general or item-specific.
• You can define a general rule table and link it to one or more items.
• You can also define an item-specific rule table. It can only be maintained for the particular item for which it was created.
QAD Configurator guides you through defining a rule table, according to the following steps:
1 Select Condition
2 Set Value for Condition
3 Select Conclusion
4 Set Value for Conclusion
When defining an item-specific rule table you use features instead of variables.
The maximum number of variables in a single rule table is 20. You can have as many condition variables (IF) and as many result variables (THEN) as you want, as long as the total does not exceed 20. A variable has an ID, an extent, and an attribute. Each row in the table represents a rule.
Example: The rule:
if U-height <= 120 and U-width >80 and U-depth <= 80
then steel-small = 2 and steel-large = 4
is shown as follows:
 
IF
U-height:
Value
IF
U-width:
Value
IF
U-length:
Value
THEN
steel-small:
Value
THEN
steel-large:
Value
:120
[:80]
:80
2
4
Special syntax-rules have been devised for the contents of the cells of the rule tables.
The following entries are possible:
 
Entry
Meaning
value1
value1
value1|value2|value3
value1 or value2 or value3
value1:value2
>= value1 and <= value2
:value1
<= value1
value1:
>= value1
[value1]
not value1
[value1|value2|value3]
not value1 and not value2 and not value3
[value1:value2]
< value1 or > value2
[:value1]
> value1
[value1:]
< value1
[value1]:value2
> value1 and <= value2
[value1]:[value2]
> value1 and < value2
value1:[value2]
>= value1 and < value2
:[value1]
< value1
[value1]:
> value1
[[value1]:value2]
<= value1 or > value2
[[value1]:[value2]]
<= value1 or >= value2
[value1:[value2]]
< value1 or >= value2
[:[value1]]
>= value1
[[value1]:]
<= value1
Entering a list of values and/or using exclusions for a result variable is only possible if all of the following conditions are met:
• The result variable is of the type Text, Numeric List, or Date
• The attribute of the result variable is value.
Otherwise, lists and exclusions are meaningless and therefore not allowed.
You can move through the cells of a table by using Tab, Shift + Tab, Page Up, Page Down, Up Arrow and Down Arrow on the keyboard.
Note: For rule tables, there is no equivalent to the concept of rule groups.
Rules in a table can only be built from the variables in the table. However, not every variable is used in a rule. So a column belonging to a variable can have empty cells for some rules in the table.