job_prod_rule

wo_id

string40

Y

N

Identify work order

oper_id

string40

Y

N

Identify producing operation

seq_no

int32

Y

N

Identify row in job table for entity at which decision is made

outcome_no

int32

Y

N

Enumerate possible outcome

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 is 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

next_oper_id

string40

N

Y

Downstream operation if relation is true, or stored procedure chooses this outcome. Null for the "End" pseudo-job.

next_seq_no

int32

N

Y

Downstream job if relation is true, or stored procedure chooses this outcome. Null for the "End" pseudo-job.

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.