Update(Int32,Int32,Int32,String,String,String,Nullable<Int32>,Nullable<Int32>,Double,Double,Nullable<Int32>,DateTime,Nullable<DateTime>,Nullable<DateTime>,String,String,Nullable<Int32>,String,String,String,String,String,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 4 minute read
The Update() method updates all columns of the specified item inventory record in the Item_Inv table.
For this overload of the method, the inventory record date input parameters are passed in UTC.
'Declaration
Public Overloads Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal rowId As Integer, _
ByVal entId As Integer, _
ByVal itemId As String, _
ByVal lotNo As String, _
ByVal subLotNo As String, _
ByVal gradeCd As Nullable(Of Integer), _
ByVal statusCd As Nullable(Of Integer), _
ByVal qtyLeft As Double, _
ByVal qtyLeftErp As Double, _
ByVal uomId As Nullable(Of Integer), _
ByVal dateInUtc As Date, _
ByVal dateOutUtc As Nullable(Of Date), _
ByVal expiryDateUtc As Nullable(Of Date), _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal spare5 As String, _
ByVal spare6 As String, _
ByRef lastEditAt As Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim rowId As Integer
Dim entId As Integer
Dim itemId As String
Dim lotNo As String
Dim subLotNo As String
Dim gradeCd As Nullable(Of Integer)
Dim statusCd As Nullable(Of Integer)
Dim qtyLeft As Double
Dim qtyLeftErp As Double
Dim uomId As Nullable(Of Integer)
Dim dateInUtc As Date
Dim dateOutUtc As Nullable(Of Date)
Dim expiryDateUtc As Nullable(Of Date)
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim spare5 As String
Dim spare6 As String
Dim lastEditAt As Nullable(Of Date)
ItemInv.Update(sessionId, rowId, entId, itemId, lotNo, subLotNo, gradeCd, statusCd, qtyLeft, qtyLeftErp, uomId, dateInUtc, dateOutUtc, expiryDateUtc, woId, operId, seqNo, spare1, spare2, spare3, spare4, spare5, spare6, lastEditAt)
public static void Update(
int sessionId,
int rowId,
int entId,
string itemId,
string lotNo,
string subLotNo,
Nullable<int> gradeCd,
Nullable<int> statusCd,
double qtyLeft,
double qtyLeftErp,
Nullable<int> uomId,
DateTime dateInUtc,
Nullable<DateTime> dateOutUtc,
Nullable<DateTime> expiryDateUtc,
string woId,
string operId,
Nullable<int> seqNo,
string spare1,
string spare2,
string spare3,
string spare4,
string spare5,
string spare6,
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 ID of the row.
- entId
Required. Holds the ID of the entity.
- itemId
Required. Holds the ID of the item.
- lotNo
Required. Holds the lot number of the item.
- subLotNo
Required. Holds an sublot number of the item.
- gradeCd
Required. Holds the grade code of the item. Set to null if it should default to the grade code of the lot or sublot.
- statusCd
Required. Holds the status code of the item. Set to null if it should default to the status code of the lot or sublot.
- qtyLeft
Required. Holds the quantity that is remaining in the entity.
- qtyLeftErp
Required. Holds the quantity that is remaining in the entity, as last transmitted to an ERP system. The default is 0.
- uomId
Required. Holds the ID of the unit of measure that is used for the item in the inventory record if the inventory UOM is different than its native UOM. If null, then the UOM in the inventory record is the item's native UOM.
- dateInUtc
Required. Holds the date and time when the items were last received to this lot or location in UTC.
- dateOutUtc
Required. Holds the date and time when the items were last sent from this lot or location in UTC.
- expiryDateUtc
Required. Holds the item's expiry date and time in UTC.
- woId
Required. Holds the ID of the work order for the last job that produced these goods.
- operId
Optional. Holds the ID of the operation for the last job that produced these goods.
- seqNo
Optional. Holds the operation sequence number for the last job that produced these goods.
- 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.
- spare5
Required. Holds the contents of the user-defined spare5 field.
- spare6
Required. Holds the contents of the user-defined spare6 field.
- 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.