Conditions and Evaluations
208
Integration Guide
The following table lists the possible types of comparison fields that you can use
in the field comparisons. Comparison of an alphanumeric source field is case
sensitive.
Field Use
Integration control Compare the value in the specified field with the values
in a list or value integration control. If a list control has
multiple matching values, the evaluation is true. The true
evaluation occurs only if the field value matches any one
of the values in the list control.
Example: Validate the STATUS of a purchase order. The
current value in a STATUS field is WAPPR and the
possible acceptable values that satisfy the condition are
in a list control called POSEND. The values in POSEND
are WAPPR, APPR, and CLOSE. If the evaluation type is
EQUALS, the evaluation returns a true value.
Value Compare the value in the specified field with a
predefined value. This option is available for
user-defined conditions.
Regardless of the locale setting of the application server
or the database, all decimal fields must use a period (.) as
the decimal placeholder. Numbers to the left of the
placeholder are not formatted. This format applies to
inbound and outbound data. For example, $1,738,593.64
must be in the following format: 1738593.64.
Example: A processing rule compares the value of the
POLIN1 field with the value SPARE. If the evaluation
type is EQUALS and the two values are the same, the
evaluation returns a true value.
MAXVAR Compare the value in the specified field with the value in
a system control (a value in the MAXVARS database
table).
Evaluate the OWNERSYSID on any enterprise service or
publish channel to determine if it is the same as
MAXVARS.MXSYSID.
Boolean Compare the value in the specified field with a Boolean
value (true or false).
Comparison field Compare the value in the specified field with another
field in the same object.
Example: Compare the GLDEBITACCT value and
GLCREDITACCT value on a PO line or a journal entry to
determine if they are equal.
Object
relationship, and
field
Compare the value in the specified field with a field in a
different object.
Example: Check the OWNERSYSID of inventory in the
system for the item-storeroom values on a receipt line or
a PO Line.
To Next Page
Loading...