Invantive Estate

Value Formulas

In this form you can register and change value formulas. Open screen in browser Open Form

A value formula is a formula in the form of an SQL statement which is used to check the integrity of the data recorded in Invantive Estate.

See Soll Valuesfor a more extensive explanation.

Value Formulas Screen

The meaning of the entry fields is:

Code

The code of the formula.

Description

The description of the formula.

Formula

The formula in the form of an SQL query.

You can use variable texts, supplied by the Soll value. The variable texts are defined as ‘:1’ to ‘:10’.