MES Stateless API

Update Method (SoLine)

Save PDF

Update Method (SoLine)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The Update() method updates all 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.

Syntax

'Declaration
 
Public Shared Sub Update( _
   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 Double, _
   ByVal uomId As DBInt, _
   ByVal minQuantity As 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 Double
Dim uomId As DBInt
Dim minQuantity As 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.Update(sessionId, custId, poId, soLineNo, itemId, customerItemId, quantity, uomId, minQuantity, maxQuantity, linePrice, requiredByLocal, spare1, spare2, spare3, spare4, lastEditComment, modId)

public static void Update( 
   int sessionId,
   string custId,
   string poId,
   int soLineNo,
   string itemId,
   DBString customerItemId,
   double quantity,
   DBInt uomId,
   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

Required. Holds the ID of the item being ordered.

customerItemId

Required. Holds the ID used by the customer to identify the item being ordered.

quantity

Required. Holds the nominal amount of the item being ordered.

uomId

Required. Holds the ID of the unit of measure of the item for the sales order.

minQuantity

Required. 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

Required. Holds the maximum quantity that may be shipped against this line item. A null value indicates no limit.

linePrice

Required. Holds the total price for this line item.

requiredByLocal

Required. 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

Required. Holds the contents of the user-defined spare1 field.

spare2

Required. Holds the contents of the user-defined spare2 field.

spare3

Required. Holds the contents of the user-defined spare3 field.

spare4

Required. Holds the contents of the user-defined spare4 field.

lastEditComment

Required. 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 modId value in the record for the update to succeed.

Output. Holds the new modification ID to identify this update of this record.

MES Stateless API