UpdateSpecific Method (Receipt)
- Last UpdatedNov 06, 2025
- 3 minute read
The UpdateSpecific() method updates specific columns for the specified receipt record in Receipt table.
The receipt is uniquely identified by the combination of the purchase order ID, date received, and item ID.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal poId As String, _
ByVal dateReceivedUtc As Date, _
ByVal itemId As String, _
ByVal poLineNumber As DBInt, _
ByVal vendorId As DBString, _
ByVal invoice As DBString, _
ByVal receivedBy As DBString, _
ByVal receivedAt As DBInt, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByRef lastEditAt As Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim poId As String
Dim dateReceivedUtc As Date
Dim itemId As String
Dim poLineNumber As DBInt
Dim vendorId As DBString
Dim invoice As DBString
Dim receivedBy As DBString
Dim receivedAt As DBInt
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditAt As Nullable(Of Date)
Receipt.UpdateSpecific(sessionId, poId, dateReceivedUtc, itemId, poLineNumber, vendorId, invoice, receivedBy, receivedAt, spare1, spare2, spare3, spare4, lastEditAt)
public static void UpdateSpecific(
int sessionId,
string poId,
DateTime dateReceivedUtc,
string itemId,
DBInt poLineNumber,
DBString vendorId,
DBString invoice,
DBString receivedBy,
DBInt receivedAt,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
ref Nullable<DateTime> lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- poId
- Required. Holds the ID of the purchase order with which the goods received are associated.
- dateReceivedUtc
- Required. Holds the date and time when the goods were received, in UTC.
- itemId
- Required. Holds the ID of the item for the goods received.
- poLineNumber
- Optional. Holds the PO line number of the goods received.
- vendorId
- Optional. Holds the vendor ID.
- invoice
- Optional. Holds the invoice or bill of lading number for the goods received.
- receivedBy
- Optional. Holds the name of who received the goods.
- receivedAt
- Optional. Holds the ID of the entity at which the goods were received.
- 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.
- 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.
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.