Update(Int32,Int32,String,String,Int32,DateTime,String,DBString,DBString,DBString,DBString,Int32,String,Int32,Int32,Int32,Int32,DBInt,Boolean,Double,Double,Int32,Boolean,DBString,Int32,DBString,DBString,DBString,DBString,DBString,DBString,DBString,DBString,DBString,DBString,DateTime) Method
- Last UpdatedNov 06, 2025
- 5 minute read
The Update() method updates all columns of the specified item production record in the Item_Prod table.
This overload of the method includes the shiftStart and shiftId parameters. It does not include the hourStart or createdAtUtc parameters.
'Declaration
Public Overloads Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal rowId As Integer, _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Integer, _
ByVal shiftStart As Date, _
ByVal itemId As String, _
ByVal lotNo As DBString, _
ByVal rmLotNo As DBString, _
ByVal subLotNo As DBString, _
ByVal rmSubLotNo As DBString, _
ByVal reasCd As Integer, _
ByVal userId As String, _
ByVal entId As Integer, _
ByVal shiftId As Integer, _
ByVal gradeCd As Integer, _
ByVal statusCd As Integer, _
ByVal toEntId As DBInt, _
ByVal goodProd As Boolean, _
ByVal qtyProd As Double, _
ByVal qtyProdErp As Double, _
ByVal processedFlag As Integer, _
ByVal byproduct As Boolean, _
ByVal extRef As DBString, _
ByVal moveStatus As Integer, _
ByVal genealogyId As DBString, _
ByVal eventId As DBString, _
ByVal segmentRequirementId As DBString, _
ByVal segmentResponseId As DBString, _
ByVal comments As DBString, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim rowId As Integer
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim shiftStart As Date
Dim itemId As String
Dim lotNo As DBString
Dim rmLotNo As DBString
Dim subLotNo As DBString
Dim rmSubLotNo As DBString
Dim reasCd As Integer
Dim userId As String
Dim entId As Integer
Dim shiftId As Integer
Dim gradeCd As Integer
Dim statusCd As Integer
Dim toEntId As DBInt
Dim goodProd As Boolean
Dim qtyProd As Double
Dim qtyProdErp As Double
Dim processedFlag As Integer
Dim byproduct As Boolean
Dim extRef As DBString
Dim moveStatus As Integer
Dim genealogyId As DBString
Dim eventId As DBString
Dim segmentRequirementId As DBString
Dim segmentResponseId As DBString
Dim comments As DBString
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
ItemProd.Update(sessionId, rowId, woId, operId, seqNo, shiftStart, itemId, lotNo, rmLotNo, subLotNo, rmSubLotNo, reasCd, userId, entId, shiftId, gradeCd, statusCd, toEntId, goodProd, qtyProd, qtyProdErp, processedFlag, byproduct, extRef, moveStatus, genealogyId, eventId, segmentRequirementId, segmentResponseId, comments, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int rowId,
string woId,
string operId,
int seqNo,
DateTime shiftStart,
string itemId,
DBString lotNo,
DBString rmLotNo,
DBString subLotNo,
DBString rmSubLotNo,
int reasCd,
string userId,
int entId,
int shiftId,
int gradeCd,
int statusCd,
DBInt toEntId,
bool goodProd,
double qtyProd,
double qtyProdErp,
int processedFlag,
bool byproduct,
DBString extRef,
int moveStatus,
DBString genealogyId,
DBString eventId,
DBString segmentRequirementId,
DBString segmentResponseId,
DBString comments,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref DateTime lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- rowId
- Required. Holds the row ID of an item production record to be updated.
- woId
- Required. Holds the work order ID for identifying the job that produced the item.
- operId
- Required. Holds the operation ID for identifying the job that produced the item.
- seqNo
- Required. Holds the operation sequence number for identifying the job that produced the item.
- shiftStart
- Required. Holds the start time of the shift during which an item was produced.
- itemId
- Required. Holds the item ID.
- lotNo
- Required. Holds the lot number to which the item belongs.
- rmLotNo
- Required. Holds the lot number of the raw material from which the lot/sublot was produced.
- subLotNo
- Required. Holds the sublot number to which the item belongs.
- rmSubLotNo
- Required. Holds the sublot number of the raw material from which the lot/sublot was produced.
- reasCd
- Required. Holds a reason code that uniquely identifies grade + status of goods produced.
- userId
- Required. Holds the ID of the user who ran the job that produced the item.
- entId
- Required. Holds the ID of the entity on which the job that produced the item is running.
- shiftId
- Required. Holds the ID of the shift during which the item was produced.
- gradeCd
- Required. Holds the grade code of a produced item.
- statusCd
- Required. Holds the status code of a produced item.
- toEntId
- Required. Holds the ID of the storage entity to which the produced item was moved.
- goodProd
- Required. Holds a flag that, if set to true, specifies that the item is designated as good production.
- qtyProd
- Required. Holds the quantity produced.
- qtyProdErp
- Required. Holds the quantity produced value that has been reported to an ERP system.
- processedFlag
- Required. Holds a flag that, if set to true, specifies that the item was processed.
- byproduct
- Required. Holds a flag that, if set to true, specifies that the item is a by-product.
- extRef
- Required. Holds the reference to the external system for defect tracking or any other purpose.
- moveStatus
Required. Holds an integer that indicates whether the lot been moved to the next operation.
0=not moved to the next operation
1=moved to the next operation
- genealogyId
- Required. Required. Holds the genealogy ID.
- eventId
- Required. Holds the event ID.
- segmentRequirementId
- Required. Holds the segment requirement ID.
- segmentResponseId
- Required. Holds the segment response ID.
- comments
- Required. Holds comments about the produced item.
- spare1
- Required. Holds the contents of the user-defined spare1 field.
- spare2
- Required. Holds the contents of the user-defined spare2 field.
- spare3
- Required. Holds the contents of the user-defined spare3 field.
- spare4
- Required. Holds the contents of the user-defined spare4 field.
- lastEditComment
- Required. Holds comments that describe why this record is being updated.
- lastEditAt
Optional. Holds the date/time when this record was added or last updated, for optimistic concurrency control. If it is specified, the passed value must match the lastEditAt value in the record for the update to succeed. If a null value is passed, then optimistic concurrency will not be used.
Output. Holds the date/time value when the record was updated by this called method.