item_prod

wo_id

string40

N

N

Identify work order

oper_id

string40

N

N

Identify operation

seq_no

int32

N

N

Identify job table row

shift_start_utc

tdatetime

N

N

Timestamp of shift start in UTC

shift_start_local

tdatetime

N

N

Timestamp of shift start in local time

hour_start_utc

tdatetime

N

N

Timestamp of (local) hour in which production occurred, in UTC.

Note that the minutes and seconds will always be zero (0).

hour_start_local

tdatetime

N

N

Timestamp of (local) hour in which production occurred, in local time.

Note that the minutes portion will not be zero (0) if the time zone is not an integer number of hours different from UTC.

item_id

string40

N

N

Item identifier

lot_no

string40

N

Y

Lot number

rm_lot_no

string40

N

Y

If disassembly, lot number of raw material from which this lot/sublot was produced.

sublot_no

string40

N

Y

Sublot number

rm_sublot_no

string40

N

Y

If disassembly, sublot number of raw material from which this lot/sublot was produced.

reas_cd

int32

N

N

Reason uniquely identifies grade + status of goods produced

user_id

string40

N

N

User ID making this entry

ent_id

int32

N

N

On which entity job ran

shift_id

int32

N

N

Shift identifier

grade_cd

int32

N

N

Grade code of produced goods

status_cd

int32

N

N

Status code of produced goods

to_ent_id

int32

N

Y

Storage entity id for produced goods

good_prod

logical

N

N

Yes (default) if good production, No if rejects.

qty_prod

tfloat

N

N

Quantity produced

qty_prod_erp

tfloat

N

N

Qty produced transferred to ERP. Default = 0.

processed_flag

int32

N

N

Processed flag for this lot. Default = 0.

byproduct

logical

N

N

Yes = byproduct, No (default) = main production item.

ext_ref

string40

N

Y

Reference to external system for defect tracking or any other purpose

move_status

int32

N

N

Has this ‘lot’ been moved to next operation or not. Default = 0 which is No.

genealogy_id

string254

N

Y

PEM intra-segment genealogy ID

event_id

string80

N

Y

PEM production event ID

segment_requirement_id

string80

N

Y

S95 segment requirement ID

segment_response_id

string80

N

Y

S95 segment response ID

comments

string254

N

Y

Comments for a production transaction

spare1

string80

N

Y

Use defined by language term 691

spare2

string80

N

Y

Use defined by language term 692

spare3

string80

N

Y

Use defined by language term 765

spare4

string80

N

Y

Use defined by language term 766

last_edit_comment

notes

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 data was entered or last edited. Used as a mod_id field for updates.

created_at_utc

tdatetime

N

N

When record created in UTC

created_at_local

tdatetime

N

N

When record created in local time

row_id

ID 1

Y

N

Unique identifier for row (a production transaction)