Update Method (ItemTransfer)
- Last UpdatedNov 06, 2025
- 6 minute read
The Update() method updates all columns of the specified item transfer record in the Item_Transfer table.
'Declaration
Public Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal transId As Integer, _
ByVal woId As DBString, _
ByVal operId As DBString, _
ByVal seqNo As DBInt, _
ByVal bomPos As DBInt, _
ByVal toEntId As DBInt, _
ByVal itemId As String, _
ByVal lotNo As DBString, _
ByVal subLotNo As DBString, _
ByVal gradeCd As DBInt, _
ByVal statusCd As DBInt, _
ByVal qtyTxd As Double, _
ByVal uomId As DBInt, _
ByVal expiryDate As DBDateTime, _
ByVal toSpare1 As DBString, _
ByVal toSpare2 As DBString, _
ByVal toSpare3 As DBString, _
ByVal toSpare4 As DBString, _
ByVal toSpare5 As DBString, _
ByVal toSpare6 As DBString, _
ByVal fromWoId As DBString, _
ByVal fromOperId As DBString, _
ByVal fromSeqNo As DBInt, _
ByVal fromEntId As DBInt, _
ByVal fromItemId As DBString, _
ByVal fromLotNo As DBString, _
ByVal fromSubLotNo As DBString, _
ByVal fromGradeCd As DBInt, _
ByVal fromStatusCd As DBInt, _
ByVal fromQtyTxd As DBDouble, _
ByVal fromUomId As DBInt, _
ByVal fromExpiryDate As DBDateTime, _
ByVal fromSpare1 As DBString, _
ByVal fromSpare2 As DBString, _
ByVal fromSpare3 As DBString, _
ByVal fromSpare4 As DBString, _
ByVal fromSpare5 As DBString, _
ByVal fromSpare6 As DBString, _
ByVal qtyTxdErp As DBDouble, _
ByVal goodsReceived As Boolean, _
ByVal goodsShipped As Boolean, _
ByVal transferListRowId As DBInt, _
ByVal comments As DBString, _
ByRef modId As String _
)
'Usage
Dim sessionId As Integer
Dim transId As Integer
Dim woId As DBString
Dim operId As DBString
Dim seqNo As DBInt
Dim bomPos As DBInt
Dim toEntId As DBInt
Dim itemId As String
Dim lotNo As DBString
Dim subLotNo As DBString
Dim gradeCd As DBInt
Dim statusCd As DBInt
Dim qtyTxd As Double
Dim uomId As DBInt
Dim expiryDate As DBDateTime
Dim toSpare1 As DBString
Dim toSpare2 As DBString
Dim toSpare3 As DBString
Dim toSpare4 As DBString
Dim toSpare5 As DBString
Dim toSpare6 As DBString
Dim fromWoId As DBString
Dim fromOperId As DBString
Dim fromSeqNo As DBInt
Dim fromEntId As DBInt
Dim fromItemId As DBString
Dim fromLotNo As DBString
Dim fromSubLotNo As DBString
Dim fromGradeCd As DBInt
Dim fromStatusCd As DBInt
Dim fromQtyTxd As DBDouble
Dim fromUomId As DBInt
Dim fromExpiryDate As DBDateTime
Dim fromSpare1 As DBString
Dim fromSpare2 As DBString
Dim fromSpare3 As DBString
Dim fromSpare4 As DBString
Dim fromSpare5 As DBString
Dim fromSpare6 As DBString
Dim qtyTxdErp As DBDouble
Dim goodsReceived As Boolean
Dim goodsShipped As Boolean
Dim transferListRowId As DBInt
Dim comments As DBString
Dim modId As String
ItemTransfer.Update(sessionId, transId, woId, operId, seqNo, bomPos, toEntId, itemId, lotNo, subLotNo, gradeCd, statusCd, qtyTxd, uomId, expiryDate, toSpare1, toSpare2, toSpare3, toSpare4, toSpare5, toSpare6, fromWoId, fromOperId, fromSeqNo, fromEntId, fromItemId, fromLotNo, fromSubLotNo, fromGradeCd, fromStatusCd, fromQtyTxd, fromUomId, fromExpiryDate, fromSpare1, fromSpare2, fromSpare3, fromSpare4, fromSpare5, fromSpare6, qtyTxdErp, goodsReceived, goodsShipped, transferListRowId, comments, modId)
public static void Update(
int sessionId,
int transId,
DBString woId,
DBString operId,
DBInt seqNo,
DBInt bomPos,
DBInt toEntId,
string itemId,
DBString lotNo,
DBString subLotNo,
DBInt gradeCd,
DBInt statusCd,
double qtyTxd,
DBInt uomId,
DBDateTime expiryDate,
DBString toSpare1,
DBString toSpare2,
DBString toSpare3,
DBString toSpare4,
DBString toSpare5,
DBString toSpare6,
DBString fromWoId,
DBString fromOperId,
DBInt fromSeqNo,
DBInt fromEntId,
DBString fromItemId,
DBString fromLotNo,
DBString fromSubLotNo,
DBInt fromGradeCd,
DBInt fromStatusCd,
DBDouble fromQtyTxd,
DBInt fromUomId,
DBDateTime fromExpiryDate,
DBString fromSpare1,
DBString fromSpare2,
DBString fromSpare3,
DBString fromSpare4,
DBString fromSpare5,
DBString fromSpare6,
DBDouble qtyTxdErp,
bool goodsReceived,
bool goodsShipped,
DBInt transferListRowId,
DBString comments,
ref string modId
)
Parameters
- sessionId
Required. Holds the session ID and thus the user who is making this method call.
- transId
Required. Holds the ID of the item transfer.
- woId
Required. Holds the work order ID for the job for which transfer occurred while recording an allocation. If the producing job is changed, the woId parameter specifies the work order ID by which the inventory was produced.
- operId
Required. Holds the ID of the operation for the job. If the producing job is changed, the operId parameter specifies the new operation ID by which the inventory was produced.
- seqNo
Required. Holds the sequence number for the operation. If the producing job is changed, the seqNo parameter specifies the new sequence number by which the inventory was produced.
- bomPos
Required. Holds the BOM position.
- toEntId
Required. Holds the ID of the destination entity.
- itemId
Required. Holds the ID of the item being transferred.
- lotNo
Required. Holds the lot number of the item being transferred.
- subLotNo
Required. Holds the sublot number of the item being transferred.
- gradeCd
Required. Holds the grade code of the material that is being transferred.
- statusCd
Required. Holds the status code of the material being transferred.
- qtyTxd
Required. Holds the quantity of the item being transferred.
- uomId
Required. Holds the ID of the unit of measure for the quantity being transferred.
- expiryDate
Required. Holds the expiry date and time for the item at the destination storage entity in the local time of that entity.
- toSpare1
Required. Holds the contents of the user-defined toSpare1 field.
- toSpare2
Required. Holds the contents of the user-defined toSpare2 field.
- toSpare3
Required. Holds the contents of the user-defined toSpare3 field.
- toSpare4
Required. Holds the contents of the user-defined toSpare4 field.
- toSpare5
Required. Holds the contents of the user-defined toSpare5 field.
- toSpare6
Required. Holds the contents of the user-defined toSpare6 field.
- fromWoId
Required. Holds the ID of the work order by which the inventory was produced.
- fromOperId
Required. Holds the ID of the operation by which the inventory was produced.
- fromSeqNo
Required. Holds the sequence number by which inventory was produced.
- fromEntId
Required. Holds the ID of the entity from where the transfer occurs.
- fromItemId
Required. Holds the ID of an item that is transferred from the old location. If null, the itemId is used.
- fromLotNo
Required. Holds a lot number that is transferred from the old location. If null, the lotNo is used.
- fromSubLotNo
Required. Holds a sublot number that is transferred from the old location. If null, the subLotNo is used.
- fromGradeCd
Required. Holds the grade code of a material that is transferred from the old location. If null, the gradeCd is used.
- fromStatusCd
Required. Holds the status code of a material that is transferred from the old location. If null, the statusCd is used.
- fromQtyTxd
Required. Holds the quantity of the item that is transferred from the old location. If null, the qtyTxd is used.
- fromUomId
Required. Holds the ID of the unit of measure for the quantity that is transferred from the old location. If null, the uomId is used.
- fromExpiryDate
Required. Holds the inventory's expiry date and time at the source storage entity in the local time of that entity. If null, the expiryDate value is used.
- fromSpare1
Required. Holds the value of Item_Inv.Spare1 prior to the transfer.
- fromSpare2
Required. Holds the value of Item_Inv.Spare2 prior to the transfer.
- fromSpare3
Required. Holds the value of Item_Inv.Spare3 prior to the transfer.
- fromSpare4
Required. Holds the value of Item_Inv.Spare4 prior to the transfer.
- fromSpare5
Required. Holds the value of Item_Inv.Spare5 prior to the transfer.
- fromSpare6
Required. Holds the value of Item_Inv.Spare6 prior to the transfer.
- qtyTxdErp
Required. Holds the quantity of the item being transferred that is sent to an ERP system.
- goodsReceived
Required. Holds a flag that, if set to true, specifies that the goods are received from the supplier. The default is false.
- goodsShipped
Required. Holds a flag that, if set to true, specifies that the goods are shipped to the customer. The default is false.
- transferListRowId
Required. Holds the ID of the transfer list record for which this row is a partial or complete fulfillment.
- comments
Required. Holds the explanatory notes for this inventory transfer.
- modId
Required. Holds the modification ID assigned the last time this record was added or last updated, for optimistic concurrency control. The passed value must match the record's modId for the record to be updated.
Output. Holds the new modification ID to identify this update of this record.