2 6 3 Code Table Lookup Check Examples

You are here:

These examples are provided to illustrate the use of the code table lookup rule facility:

Example 1

Column being checked:

Name	Type	Len	Dec
PRODNO	A	10

Table details:

Name	Actual Keys	Keys Supplied	Comments
PRODMST	Product number	PRODNO	Check product is in product master

Example 2

Column being checked:

Name	Type	Len	Dec
TAXCDE	A	3

Table details:

Name	Actual Keys	Keys Supplied	Comments
TAXTABL	Tax code type	INCOME	Check TAXCDE is a valid income tax code using alpha literal 'INCOME' in the key list.
	Tax code	TAXCDE

Example 3

Column being checked:

Name	Type	Len	Dec
PARTNO	P	7	0

Table details:

Name	Actual Keys	Keys Supplied	Comments
INVENT	Part number Warehouse number	PARTNO	Check PARTNO exists. This is a "partial" key validation check.

Example 4

Column being checked:

Name	Type	Len	Dec
INVNUM	A	8

Table details:

Name	Actual Keys	Keys Supplied	Comments
INVNUM	Invoice number	INVNUM	Check INVNUM does not already exist. Reverse default error logic to get ERROR if key match is found, NEXT if key match is NOT found.