Code Translation

Code: H

This function will look up a parameter table in class 1, and either Translates the code supplied into text or validate the code and Translates it into an integer.

It is very similar in functionality to the T function, the difference is that this function looks up the table number two obtain the table type.Oak VAT Table.

The H function translations use the visual key to the actual numeric code, and extension-1 can be used two giving the table a 2 dimensional function.

Parameter	Value	Parameter	Value	Description
0	2-18			Record the area code information
1	1-99			Table number in class 1
2	0-255			Default value.
	Default			Mandatory
	_ (Underscore)			No change if the item is blank
6-8				Passed two function G as parameter 1, 4 and 7 if the translation fails. Not performed when printing totals.
9	1-9999			Subset of Code
	Default			Any subset

Two Dimensional Table Processing

Two Dimensional Tables are used when you need to combine conditions from two different tables.Oak Discount processing that is determined by a combination of Customer Group and Product Group.

Example: Processing an order where the customer has a customer group of A while the Product has a group of Y.This combination determines the discount percentage to be used by reference to two parameter tables.The parameters would be set up as follows:

Parameter Table 1:

A parametric two validate the product group and at the same time Determine the code to be used for this part of the discount decision.

This parameter will be accessed using a T function code on the product group data item, refer to Figure 4 for the parameter format.

Table No.	Visual Key	Extension 1	Code	Description
1	0048	1	X	Product group X
1	0048	2	Y	Product group Y
1	0048	3	Z	Product group Z

When this parameter is looked up the y product group will be associated with the code 2 (obtained from the extension 1).

Parameter Table 2:

A parametric two validate the customer group and at the same time Determine the code to be used for this part of the discount decision.

This parameter will be accessed using an H function code on the customer group data item, it has the following format.

Total no	Visual Key	Extension 1	Code	Discount	Description
45	0001		A		Customer Group A
45	0001	1		3%	Discount for Product group X
45	0001	2		10%	Discount for Product group X
45	0001	3		12%	Discount for Product group X

When this parameter is looked up the A customer group will be associated with the code 0001 (obtained from the visual-key) and the Code 2 (obtained earlier from the

Product group lookup) is used to find the extension-1 record (two corresponding y) which will have the correct discount% discount in the data item.