UpdateSpecific Method (SoLine)
- Last UpdatedNov 06, 2025
- 3 minute read
The UpdateSpecific() method updates selected columns of the specified sales order line item record in the SO_Line table.
The sales order line is uniquely identified by the combination of the customer ID, purchase order ID, and SO line number.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal custId As String, _
ByVal poId As String, _
ByVal soLineNo As Integer, _
ByVal itemId As String, _
ByVal customerItemId As DBString, _
ByVal quantity As Nullable(Of Double), _
ByVal uomId As DBInt, _
ByVal minQuantity As Nullable(Of Double), _
ByVal maxQuantity As DBDouble, _
ByVal linePrice As DBDouble, _
ByVal requiredByLocal As DBDateTime, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef modId As String _
)
'Usage
Dim sessionId As Integer
Dim custId As String
Dim poId As String
Dim soLineNo As Integer
Dim itemId As String
Dim customerItemId As DBString
Dim quantity As Nullable(Of Double)
Dim uomId As DBInt
Dim minQuantity As Nullable(Of Double)
Dim maxQuantity As DBDouble
Dim linePrice As DBDouble
Dim requiredByLocal As DBDateTime
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim modId As String
SoLine.UpdateSpecific(sessionId, custId, poId, soLineNo, itemId, customerItemId, quantity, uomId, minQuantity, maxQuantity, linePrice, requiredByLocal, spare1, spare2, spare3, spare4, lastEditComment, modId)
public static void UpdateSpecific(
int sessionId,
string custId,
string poId,
int soLineNo,
string itemId,
DBString customerItemId,
Nullable<double> quantity,
DBInt uomId,
Nullable<double> minQuantity,
DBDouble maxQuantity,
DBDouble linePrice,
DBDateTime requiredByLocal,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref string modId
)
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 ID of the customer's purchase order.
- soLineNo
- Required. Holds a number that identifies the line item in the sales order.
- itemId
- Optional. Holds the ID of the item being ordered.
- customerItemId
- Optional. Holds the ID used by the customer to identify the item being ordered.
- quantity
- Optional. Holds the nominal amount of the item being ordered.
- uomId
- Optional. Holds the ID of the unit of measure of the item for the sales order.
- minQuantity
- Optional. Holds the minimum quantity that, once shipped, will allow the sales order to be completed. If null is supplied, the value defaults to the quantity value.
- maxQuantity
- Optional. Holds the maximum quantity that may be shipped against this line item. A null value indicates no limit.
- linePrice
- Optional. Holds the total price for this line item.
- requiredByLocal
- Optional. Holds the date when the goods for this line are required in the local time of the entity from which the goods are shipped, specified by the ship_from column in the SO's record. If a ship-from entity is not specified, the default time zone will be used to determine the local time.
- 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.
- lastEditComment
- Optional. Holds comments that describes why this record is being added.
- modId
Required. Holds the modification ID assigned the last time this record was added or updated, for optimistic concurrency control. The passed value must match the record's modId value for the update to succeed.
Output. Holds the new modification ID to identify this update of this record.
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.