UpdateSpecific Method (Shipment)
- Last UpdatedNov 06, 2025
- 2 minute read
The UpdateSpecific() method updates specific columns for the specified shipment record in Shipment table.
The shipment record is uniquely identified by the combination of the customer ID, purchase order ID, SO line number, and ship date in UTC.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal custId As String, _
ByVal poId As String, _
ByVal soLineNumber As Integer, _
ByVal shipDateUtc As Date, _
ByVal shipVia As DBString, _
ByVal shipBy As DBString, _
ByVal shipFrom 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 custId As String
Dim poId As String
Dim soLineNumber As Integer
Dim shipDateUtc As Date
Dim shipVia As DBString
Dim shipBy As DBString
Dim shipFrom As DBInt
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditAt As Nullable(Of Date)
Shipment.UpdateSpecific(sessionId, custId, poId, soLineNumber, shipDateUtc, shipVia, shipBy, shipFrom, spare1, spare2, spare3, spare4, lastEditAt)
public static void UpdateSpecific(
int sessionId,
string custId,
string poId,
int soLineNumber,
DateTime shipDateUtc,
DBString shipVia,
DBString shipBy,
DBInt shipFrom,
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.
- custId
- Required. Holds the customer ID.
- poId
- Required. Holds the purchase order ID.
- soLineNumber
- Required. Holds the sales order line number of the goods shipped.
- shipDateUtc
- Required. Holds the date and time when the goods were shipped, in UTC.
- shipVia
- Optional. Holds the description of how the goods were shipped.
- shipBy
- Optional. Holds the name of who shipped the goods.
- shipFrom
- Optional. Holds the ID of the entity from which the goods were shipped.
- 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.