job

wo_id

string40

Y

N

The ID of the work order.

oper_id

string40

Y

N

The ID of the operation.

seq_no

int32

Y

N

The sequence number for the job.

job_desc

string80

N

Y

The description of the job.

item_id

string40

N

N

The ID of the item that results from this job. This item can be different from that in work order if the job is not the final job in the work order (e.g., a component part).

state_cd

int32

N

N

The job state. The default is 1 (New).

job_priority

int32

N

N

The job's operation priority. Can be a value from 0–2147483647. The default is 1.

req_finish_time_utc

tdatetime

N

Y

The required completion date and time, in UTC.

req_finish_time_local

tdatetime

N

Y

The required completion date and time, in local time.

init_sched_ent_id

int32

N

N

The entity to which the job is initially scheduled. Need to remember this even when target_sched_ent_id is changed.

target_sched_ent_id

int32

N

N

The entity to which the job is actually scheduled. This can be changed by integration with a scheduling package or manually by a user.

run_ent_id

int32

N

Y

The entity on which the job was actually run. Initially, this is null.

qty_reqd

tfloat

N

N

The required quantity of the item.

qty_prod

tfloat

N

N

The quantity of the item produced so far. The default is 0.

qty_prod_erp

tfloat

N

Y

The quantity produced as uploaded to ERP.

qty_rejected

tfloat

N

N

The quantity of the item rejected so far. The default is 0.

qty_rejected_erp

tfloat

N

Y

Quantity rejected as uploaded to ERP

qty_at_start

tfloat

N

N

The quantity we expect to produce if there are no scrap/waste/rejects

deviation_above

tfloat

N

N

Portion of start quantity by which total production may deviate above it; default to value of system attribute 103 if not created from a process

deviation_below

tfloat

N

N

Portion of start quantity by which total production may deviate below it; default to value of system attribute 104 if not created from a process

batch_size

tfloat

N

N

Amount of product per batch (default = 1). Used to force multiples of production in certain cases.

uom_id

int32

N

Y

The units of production used for actual counts.

first_job

logical

N

N

First operation for WO? Default = No

final_job

logical

N

N

Final operation for WO? Default = No

sched_pinned

logical

N

N

Start time not changeable. Default = No.

Note: This field is currently not used.

check_inv

logical

N

N

Sufficient component inventory required to change state_cd to 2 (Ready). (Default = No)

Note: This field is currently not used.

est_fixed_lab

tfloat

N

Y

Est. fixed labor hours – setup/cleanup

est_lab_rate

tfloat

N

Y

Est. variable labor batch time, depending on prod_uom.

est_setup_time

tfloat

N

Y

Est. entity hours for setup

est_teardown_
time

tfloat

N

Y

Est. entity hours for teardown

est_prod_rate

tfloat

N

N

Est. entity batch rate or time, depending on prod_uom.

prod_uom

int32

N

N

Unit of measure for est_lab_rate and est_prod_rate:

0 = hours/batch (default)

1 = minutes/batch

2 = seconds/batch

3 = batches/hour

4 = batches/minute

5 = batches/second

est_transfer_time

tfloat

N

Y

Transfer time after operation - hours

sched_start_time_utc

tdatetime

N

Y

Scheduled start time in UTC

sched_start_time_local

tdatetime

N

Y

Scheduled start time in local time

latest_start_time_utc

tdatetime

N

Y

Latest start time in UTC to meet req’d finish time

latest_start_time_local

tdatetime

N

Y

Latest start time in local time to meet req’d finish time

sched_finish_time_utc

tdatetime

N

Y

Estimated completion time in UTC

sched_finish_time_local

tdatetime

N

Y

Estimated completion time in local time

act_start_time_utc

tdatetime

N

Y

Actual start time in UTC. Always saves the first time the job was ever started (in case of restarts).

act_start_time_local

tdatetime

N

Y

Actual start time in local time. Always saves the 1st time the job was ever started (in case of restarts).

act_finish_time_utc

tdatetime

N

Y

Actual completion time in UTC. Always saves the last time the job was ever completed (in case of restarts).

act_finish_time_local

tdatetime

N

Y

Actual completion time in local time. Always saves the last time the job was ever completed (in case of restarts).

concurrent_link

int32

N

N

Match up concurrent jobs, as when punching a nest. 0=singular job (default)

job_cost

tfloat

N

Y

Additional (non-labor, non-machine, non-material) cost associated specifically with this job

parent_contingent_job

logical

N

N

Is this job for a group that will really be run on one or more children? Default = No.

child_contingent_job

logical

N

N

Is this a potential job for one of a group of entities? Default = No.

notes

nvarchar(max)

N

Y

Specific notes for this job; typically for operator to read

assoc_file

string254

N

Y

The path and file name of the file associated with the job.

assoc_file_type

string254

N

Y

The file type of the file that is associated with the job. This value is entered internally, based on the file extension of the file specified in the assoc_file field.

status_notes

string1700

N

Y

Notes regarding job status; typically operator-entered when suspending, etc.

display_seq

int32

N

N

To specify sequence of jobs independently of oper_id. Used to sequence jobs in tree and flow diagram

folder_ver_id

string40

N

Y

Optional link to specify a folder version for this job

rework

logical

N

N

Yes if this job has required/does require rework. Default = No.

rework_cd

string40

N

Y

The rework behavior of this job.

rework_process_id

string40

N

Y

For rework jobs added to an existing WO, the process from which they were instantiated

spare1

string80

N

Y

Use defined by language term 4655

spare2

string80

N

Y

Use defined by language term 4656

spare3

string80

N

Y

Use defined by language term 4657

spare4

string80

N

Y

Use defined by language term 4658

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

edited_by

string40

N

Y

ID of the user who created or last modified this record (i.e., who queued this job). Named "last_edit_by" in other tables.

edit_time

tdatetime

N

N

When created or last modified; also use for mod_id. Named "last_edit_at" in other tables.

row_id

ID 1

N

N

Unique row identifier, for audit trail.