Log production and consumption
- Last UpdatedJan 31, 2025
- 2 minute read
The production or consumption data is logged into the Item_Prod or Item_Cons table respectively only if the specified quantity is not 0. A new job_event record is created with the following values while logging the production and consumption data.
|
PEM Attribute |
Column in Job_Event Table |
Comments |
|---|---|---|
|
event_type |
The event type is:
|
|
|
Equipment Id |
ent_id |
The ID of the entity that triggers the middleware call. |
|
bom_pos |
The BOM position of the production or consumption. |
|
|
Comment |
Comments |
|
|
Event Name |
value3 |
|
|
Location |
value2 |
|
|
Lot |
lot_no |
|
|
Material Id |
item_id |
|
|
Personnel List |
value4 |
|
|
Process Segment Id |
oper_id |
|
|
Production RequestId |
wo_id |
|
|
Production Schedule Id |
value1 |
|
|
Segment Requirement Id |
segment_requirement_id |
|
|
Segment Response Id |
segment_response_id |
|
|
Sublot |
sublot_no |
|
|
Serial Number List |
value5 |
|
|
Genealogy ID |
genealogy_id |
|
|
Subsegment |
subsegment_id |
|
|
Quantity |
quantity |
|
|
value6 |
The row_id from the Data_Log table that is linked to the EPA data of this transaction. |
|
|
Unit Of Measure |
value7 |
This UOM only represents the actual unit of measurement reported during production. The corresponding quantity may be stored in different units, as the quantities for the production and consumption are recorded in the native units of the item. |
If the production or consumption transaction receives a UOM ID that does not exist in the database for an item, then the specified quantities are converted to the native units of an item only if a conversion factor exists for this item in the database.
The quantities are always recorded in the native units in the production and consumption tables. If no such conversion exists for the item, an error is logged. If a blank value is specified or a value is not specified for the UOM parameter, then the quantities are reported in native units, by default.