Tables

In addition to formulas, you can also store decision tables. This means that you can store values or even other formulas for specific occurrences (or areas) of parameters. The number of parameters stored in a table is referred to as the dimension of the table.

For example, you can store processing times for obtaining the sofa depending on the sofa length. Tables are particularly useful if parameters have a limited number of input options, or if there is a limited set of results.

Example: If sofa length < 150cm then produced on machine x.

If sofa length >= 150cm then produced on machine y.

Table_Table

Window caft_tabelle_edit.psr

Field	Description
Table	Table name
Match code	Match code
Description	Table description

Test button: See Test window.

(Definition of used dimensions in table. Max. 6 dimensions)

Field	Description
Pos	Position
Varname	Name of the Variable
Designation	Designation of the Variable
UoM	Unit of measurement
Origin type	Origin of variable: - Formula - Table - Variant (from product configuration) - Item field - Order line - Manually (enter manually at run time) - beas-Script
Origin name	Name of the object from origin type
Comparison	Desired logic for comparison - = (equal) - > (greater) - < (smaller) - => (greater or equal) - <= (smaller or equal)
Change	Allow changes at run time
Type	Output of formula ("numeric", "string" or "yes\|no")
Dec	Number of decimals (if numeric)
Operation	Mark, to save the variable globally with prefix "agbez_". Then it can be accessed in a description of an operation. see Operation Variables
Cross reference	Enter a link (Only useful with origin type "manually" or "Change")
Validity	Validity of variable: - local (only within the formula and all formulas and tables called by it) - shared (within the assembly and for all following items, but not sub-assemblies) - global (in complete structure from the moment of calculation)

Test Origin button: See Test window.

(Values for positions in dimensions tab)

Tables_Values

Window caft_tabelle_werte_browse.psr

Field	Description
Pos	Position
<name of Variable 1>	Value for Variable 1
<name of Variable 2>	Value for Variable 2
<name of Variable 3>	Value for Variable 3
<name of Variable 4>	Value for Variable 4
<name of Variable 5>	Value for Variable 5
<name of Variable 6>	Value for Variable 6
Origin	Origin of variable: - Formula - Table - Variant (from product configuration) - Item field - Order line - Manually (enter manually at run time) - beas-Script
Origin name	Name of the object from origin type

Test Origin button: See Test window.

The value depends on both the color and length. This could be the required time to upholster the sofas. Values can be stored for all combinations.

Tables_variantGEN

Window caft_tabelle_dim_browse.psr

Procedure:

1) Create new table. Table name e.g. "LaborTime"

2) Select tab "Dimension" and insert table values

- Origin type: Manually ( > This value will be asked at "Runtime" and is to be inserted via Keyboard by the User)

Pos	Varname	Description	UoM	Origin type	Origin name	Comparison	Change	Type	Dec
10	length	Cover length		Manually	B	=	x	Number	2
20	color	Cover color		Manually	B	=	x	Char.

- Origin type: Variant (-> This value will be fetched at "Runtime" from the parameters (cover_len, cover_color) of the corresponding product configuration)

Pos	Varname	Description	UoM	Origin type	Origin name	Comparison	Change	Type	Dec
10	length	Cover length		Variant	cover_len	=		Number	2
20	color	Cover color		Variant	cover_color	=		Char.

3) Select tab "Values" and insert table values

Pos	length	color	Value3	Value4	Value5	Value6	Origin	Origin Name
10	10	red					Manually	5
20	15	green					Manually	6
30	20	green					Manually	8

if the length of the cover is "10" and the color is "red", then you'll get for table "LaborTime" at runtime the value "5" as result

Help URL: https://help.beascloud.com/beas202102/index.html?tables.htm