UpdateSpecific Method (ItemCons)

• Visual Basic
• C#

'Declaration
 
Public Shared Sub UpdateSpecific( _
   ByVal sessionId As Integer, _
   ByVal rowId As Integer, _
   ByVal woId As DBString, _
   ByVal operId As DBString, _
   ByVal seqNo As DBInt, _
   ByVal shiftStartLocal As DBDateTime, _
   ByVal itemId As String, _
   ByVal lotNo As DBString, _
   ByVal fgLotNo As DBString, _
   ByVal subLotNo As DBString, _
   ByVal fgSubLotNo As DBString, _
   ByVal reasCd As DBInt, _
   ByVal userId As String, _
   ByVal itemScrapped As Nullable(Of Boolean), _
   ByVal entId As DBInt, _
   ByVal shiftId As DBInt, _
   ByVal gradeCd As Nullable(Of Integer), _
   ByVal statusCd As Nullable(Of Integer), _
   ByVal fromEntId As DBInt, _
   ByVal qtyCons As Nullable(Of Double), _
   ByVal qtyConsErp As Nullable(Of Double), _
   ByVal extRef As DBString, _
   ByVal transactionType As Nullable(Of Integer), _
   ByVal genealogyId As DBString, _
   ByVal upstreamEventId 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 Nullable(Of Date) _
) 

'Usage
 
Dim sessionId As Integer
Dim rowId As Integer
Dim woId As DBString
Dim operId As DBString
Dim seqNo As DBInt
Dim shiftStartLocal As DBDateTime
Dim itemId As String
Dim lotNo As DBString
Dim fgLotNo As DBString
Dim subLotNo As DBString
Dim fgSubLotNo As DBString
Dim reasCd As DBInt
Dim userId As String
Dim itemScrapped As Nullable(Of Boolean)
Dim entId As DBInt
Dim shiftId As DBInt
Dim gradeCd As Nullable(Of Integer)
Dim statusCd As Nullable(Of Integer)
Dim fromEntId As DBInt
Dim qtyCons As Nullable(Of Double)
Dim qtyConsErp As Nullable(Of Double)
Dim extRef As DBString
Dim transactionType As Nullable(Of Integer)
Dim genealogyId As DBString
Dim upstreamEventId 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 Nullable(Of Date)
 
ItemCons.UpdateSpecific(sessionId, rowId, woId, operId, seqNo, shiftStartLocal, itemId, lotNo, fgLotNo, subLotNo, fgSubLotNo, reasCd, userId, itemScrapped, entId, shiftId, gradeCd, statusCd, fromEntId, qtyCons, qtyConsErp, extRef, transactionType, genealogyId, upstreamEventId, segmentRequirementId, segmentResponseId, comments, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)

public static void UpdateSpecific( 
   int sessionId,
   int rowId,
   DBString woId,
   DBString operId,
   DBInt seqNo,
   DBDateTime shiftStartLocal,
   string itemId,
   DBString lotNo,
   DBString fgLotNo,
   DBString subLotNo,
   DBString fgSubLotNo,
   DBInt reasCd,
   string userId,
   Nullable<bool> itemScrapped,
   DBInt entId,
   DBInt shiftId,
   Nullable<int> gradeCd,
   Nullable<int> statusCd,
   DBInt fromEntId,
   Nullable<double> qtyCons,
   Nullable<double> qtyConsErp,
   DBString extRef,
   Nullable<int> transactionType,
   DBString genealogyId,
   DBString upstreamEventId,
   DBString segmentRequirementId,
   DBString segmentResponseId,
   DBString comments,
   DBString spare1,
   DBString spare2,
   DBString spare3,
   DBString spare4,
   DBString lastEditComment,
   ref Nullable<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 the item consumption record.

woId

Optional. Holds the work order ID for identifying the job that consumed the item.

operId

Optional. Holds the operation ID for identifying the job that consumed the item.

seqNo

Optional. Holds the operation sequence number for identifying the job that consumed the item.

shiftStartLocal

Optional. Holds the start time of the shift during which the item was consumed, in the local time of the entity at which the consumption occurred.

itemId

Optional. Holds the ID of the consumed item.

lotNo

Optional. Holds the lot number of the consumed item.

fgLotNo

Optional. Holds the lot number of finished goods for which the item was consumed.

subLotNo

Optional. Holds the sublot number of the consumed item.

fgSubLotNo

Optional. Holds the sublot number of finished goods for which the item was consumed.

reasCd

Optional. Holds a reason code that uniquely identifies grade + status of goods consumed.

userId

Optional. Holds the ID of the user who ran the job that consumed the item.

itemScrapped

Optional. Holds a flag that specifies whether the item is designated as scrapped.

entId

Optional. Holds the ID of the entity on which the job that consumed the item is running.

shiftId

Optional. Holds the ID of the shift during which the item was consumed.

gradeCd

Optional. Holds the grade code of the consumed goods.

statusCd

Optional. Holds the status code of the consumed goods.

fromEntId

Optional. Holds the ID of the storage entity from which the consumed item was moved.

qtyCons

Optional. Holds the quantity consumed.

qtyConsErp

Optional. Holds the quantity consumed value that was sent to an ERP system.

extRef

Optional. Holds the reference to the external system for defect tracking or any other purpose.

transactionType

Optional. Holds an enumeration that indicates the transaction type.

0 = normal

1 = lot split

2 = combination

genealogyId

Optional. Holds a genealogy ID.

upstreamEventId

Optional. Holds the ID of an upstream event.

segmentRequirementId

Optional. Holds a segment requirement ID.

segmentResponseId

Optional. Holds a segment response ID.

comments

Optional. Holds comments about the consumed item.

spare1

Optional. Holds the contents of the user-defined spare1 field.

spare2

Optional. Holds the contents of the user-defined spare2 field.

spare3

Optional. Holds the contents of the user-defined spare3 field.

spare4

Optional. Holds the contents of the user-defined spare4 field.

lastEditComment

Optional. 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.

Output. Holds the date/time value when the record was updated by this called method.