UpdateSpecific Method (ReceiptLot)
- Last UpdatedNov 06, 2025
- 3 minute read
The UpdateSpecific() method updates specific columns for the specified receipt lot record in Receipt_Lot table.
A receipt lot record is uniquely identified by its row ID or by the combination of the purchase order ID, date received, item ID, and lot number.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal rowId As Integer, _
ByVal poId As String, _
ByVal dateReceivedUtc As Nullable(Of Date), _
ByVal itemId As DBString, _
ByVal lotNo As DBString, _
ByVal sublotNo As DBString, _
ByVal quantity As Nullable(Of Double), _
ByVal uomId As DBInt, _
ByVal transId As DBInt, _
ByRef lastEditAt As Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim rowId As Integer
Dim poId As String
Dim dateReceivedUtc As Nullable(Of Date)
Dim itemId As DBString
Dim lotNo As DBString
Dim sublotNo As DBString
Dim quantity As Nullable(Of Double)
Dim uomId As DBInt
Dim transId As DBInt
Dim lastEditAt As Nullable(Of Date)
ReceiptLot.UpdateSpecific(sessionId, rowId, poId, dateReceivedUtc, itemId, lotNo, sublotNo, quantity, uomId, transId, lastEditAt)
public static void UpdateSpecific(
int sessionId,
int rowId,
string poId,
Nullable<DateTime> dateReceivedUtc,
DBString itemId,
DBString lotNo,
DBString sublotNo,
Nullable<double> quantity,
DBInt uomId,
DBInt transId,
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 unique row ID for the record that is being updated.
- poId
- Optional. Holds the ID of a purchase order with which the goods received are associated.
- dateReceivedUtc
- Optional. Holds the date and time when the goods were received, in UTC.
- itemId
- Optional. Holds the ID of the item for the goods received.
- lotNo
- Optional. Holds the lot number of the goods received.
- sublotNo
- Optional. Holds the sublot number of the goods received.
- quantity
- Optional. Holds the quantity of the goods received
- uomId
- Optional. Holds the identifier of the unit of measure for the goods received.
- transId
- Optional. Holds the transfer identifier for the goods received.
- lastEditAt
Required. Holds the date/time when this record was added or last updated, for optimistic concurrency control. 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.
The following parameters are used to uniquely identify the corresponding record in the Receipt table: poId, itemId, and dateReceivedUtc. When changing any of these parameters, make sure that you are still specifying the target Receipt record that you want to update.
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
- Optional non-DB* parameters: Either enter a value or pass a null. If passing a null and a default value has been defined, the default value will be used for the parameter.
- Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).
- Optional DB* parameters: To enter no value for the parameter, pass DB*.null (e.g., DBInt.null). To use the default value for the parameter if one has been defined for the object being added, pass a null.