job_route

wo_id

string40

Y

N

Identify work order

oper_id

string40

Y

N

Identify operation

seq_no

int32

Y

N

Identify row (use for different lots, entities, items, etc.)

input_oper_id

string40

Y

N

Identify job from which input quantity will be gotten

input_seq_no

int32

Y

N

input_percent

tfloat

N

N

How much of input job’s production comes to this job. (Default = 100% = 1)

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

mod_id

timestamp

N

N

A binary number that increments each time the row is modified.

row_id

ID 1

N

N

Unique row identifier, for audit trail.