item_cons

wo_id

string40

N

Y

Identify work order

oper_id

string40

N

Y

Identify operation

seq_no

int32

N

Y

Identify row in job table

shift_start_utc

tdatetime

N

Y

Timestamp of shift start in UTC

shift_start_local

tdatetime

N

Y

Timestamp of shift start in local time

item_id

string40

N

N

Identifier of consumed item

lot_no

string40

N

Y

Lot number of consumed item

fg_lot_no

string40

N

Y

Lot number of parent item

sublot_no

string40

N

Y

Sublot number of consumed item

fg_sublot_no

string40

N

Y

Sublot number of parent item

reas_cd

int32

N

Y

Could be normal consumption code or a scrap reason. Also Identifies grade + status. Cannot be null if transaction_type = 0.

user_id

string40

N

N

ID of user making this entry

item_scrapped

logical

N

N

Yes if wastage, No (default) if consumed.

ent_id

int32

N

Y

On which entity job ran

shift_id

int32

N

Y

Shift identifier

grade_cd

int32

N

N

Grade code of consumed items

status_cd

int32

N

N

Status code of consumed items

from_ent_id

int32

N

Y

Storage entity from which items consumed

qty_cons

tfloat

N

N

Qty used

qty_cons_erp

tfloat

N

N

Qty used txd to ERP. (Default = 0)

ext_ref

string40

N

Y

Reference to external system for defect tracking or any other purpose

transaction_type

int32

N

N

Enumeration of transaction type:

0 = normal consumption (default)

1 = lot split

2 = lot combination

genealogy_id

string254

N

Y

PEM intra-segment genealogy ID

upstream_ event_id

string80

N

Y

Link to upstream segment production being consumed

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 consumption transaction

spare1

string80

N

Y

Use defined by language term 596

spare2

string80

N

Y

Use defined by language term 597

spare3

string80

N

Y

Use defined by language term 598

spare4

string80

N

Y

Use defined by language term 599

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 consumption transaction)