item_rule

process_id

string40

Y

N

Identify work order

oper_id

string40

Y

N

Identify which first operation

group_ent_id

int32

Y

N

Identify group entity; groups may not have overlapping members for the same operation

outcome_no

int32

Y

N

Number of possible outcome

basis

int32

N

Y

Enumeration of type of value on which decision is based:

1 = item attribute

2 = item_class attribute, null if using stored procedure

attr_id

int32

N

Y

Identify attribute; null if using stored procedure

standard_value

string80

N

Y

Value for comparison; null if using stored procedure

relational_op

int32

N

Y

Enumeration of the relational operation used to compare the attribute value against the standard:

1 = value < standard_value

2 = value = standard_value

3 = value > standard_value

4 = !stricmp(value, standard_value)

null if using stored procedure

sp_name

string40

N

Y

Name of stored procedure to run instead of evaluating relation

ent_id

int32

N

N

Entity within group_ent_id that is to be used instead of group_ent_id if relation is true, or stored procedure chooses this outcome

is_default

logical

N

N

Must be Yes for one and only one outcome_no for a given process_id, oper_id, and group_ent_id.

spare1

string1000

N

Y

Spare field

spare2

string1000

N

Y

Spare field

spare3

string1000

N

Y

Spare field

spare4

string1000

N

Y

Spare field

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

row_id

ID 1

N

N

Unique row identifier, for audit trail.