Menu 13.6.1 - Court Definition

In the Court Profile screens 2 and 3, you can apply formulas to fields 41 and greater.

To specify a CONDITION, the stored formula must begin with "IF("in the first three positions and end with a ")" in the last position.

If a CONDITION is specified, then FORMULA1 is the individual formula that is used when the condition tested TRUE and FORMULA2 is the individual formula that is used when the condition tested FALSE. If no formula is provided for a given condition, NULL value is returned.

The comma (",") is used to delimit the CONDITION and the two FORMULAs.

If no CONDITION is specified then only one formula (FORMULA1) is accepted and there will be no commas needed (or accepted) for delimiting.

Condition clause

COND format: COMPARE DATA1 SPACE OPERATOR SPACE COMPARE DATA2

e.g. IF(D15 > 5000,..) where "D15" is COMPARE DATA1, ">" is OPERATOR and "5000" is COMPARE DATA2.

COMPARE DATA1 and 2 can be composed of any of the following:

Field indicator: LAtr.Mv.Sv

"L" is a letter of the alphabet indicating the file that contains the chosen field.

"D" = Debtor (or Account), Atr range is 1-100.

"F" = Fiscal (Legal library [CU-LEGAL] items

These can be reached through Fiscal in the format of FAtr.LAtr where Fatr is the Fiscal attribute that hold the key to the CU-LEGAL file and LAtr is the attribute in the CU-LEGAL file. (There is no designating multi values or sub values in the Legal Library). In Fiscal, unless the Legal library is being accessed only the attribute will be used (except for F1.1 and F1.2). For example, F100, F1.2, F295.13

"C" = Client

"K" = Court

"J" = Jmt

"Atr" = The attribute from the file indicated.

"Mv" = The multivalue from the file and attribute indicated.

"Sv" = The sub value from the file, attribute and multivalue indicated. (Not ever valid for Fiscal.)

Number - numeric (100, -100, 100.23, .1234, etc.).

Formula - (see individual formula definition below).

*Literal – A value enclosed in single or double quotes.

*NULL – Either a literal of "" or the word NULL.

* Use in conjunction with the = and # operator only.