job_alloc_rule

wo_id

string40

Y

N

Identify work order

oper_id

string40

Y

N

Identify which first operation

seq_no

int32

Y

N

Identify row in job table for group entity

outcome_no

int32

Y

N

Enumerate possible outcome

item_id

int32

N

Y

The allocated item to be evaluated (or its substitutes); null if using stored procedure

basis

int32

N

Y

Enumeration of type of value on which decision is based:

1 = item attribute

2 = item_class attribute

3 = lot attribute

4 = grade

5 = state

null if using stored procedure

attr_id

int32

N

Y

Identify attribute if basis = 1, 2, or 3

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 wo_id, oper_id, and seq_no.

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.