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.