Split(Int32,Int32,Double,String,String,Nullable<Int32>,Nullable<DateTime>,String,String,String,String,String,Nullable<Int32>,String,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,String,String,String,String,Nullable<Double>,Nullable<Boolean>,Nullable<Boolean>) Method
- Last UpdatedNov 06, 2025
- 5 minute read
'Declaration
Public Overloads Shared Sub Split( _
ByVal sessionId As Integer, _
ByVal oldRowId As Integer, _
ByVal splitQtyProd As Double, _
ByVal newWoId As String, _
ByVal newOperId As String, _
ByVal newSeqNo As Nullable(Of Integer), _
ByVal newShiftStart As Nullable(Of Date), _
ByVal newItemId As String, _
ByVal newLotNo As String, _
ByVal newRmLotNo As String, _
ByVal newSubLotNo As String, _
ByVal newRmSubLotNo As String, _
ByVal newReasCd As Nullable(Of Integer), _
ByVal newUserId As String, _
ByVal newEntId As Nullable(Of Integer), _
ByVal newShiftId As Nullable(Of Integer), _
ByVal newToEntId As Nullable(Of Integer), _
ByVal newGenealogyId As String, _
ByVal newEventId As String, _
ByVal newSegmentRequirementId As String, _
ByVal newSegmentResponseId As String, _
ByVal newComments As String, _
ByVal splitQtyProdErp As Nullable(Of Double), _
ByVal splitProcessedFlag As Nullable(Of Boolean), _
ByVal splitByproductFlag As Nullable(Of Boolean) _
)
'Usage
Dim sessionId As Integer
Dim oldRowId As Integer
Dim splitQtyProd As Double
Dim newWoId As String
Dim newOperId As String
Dim newSeqNo As Nullable(Of Integer)
Dim newShiftStart As Nullable(Of Date)
Dim newItemId As String
Dim newLotNo As String
Dim newRmLotNo As String
Dim newSubLotNo As String
Dim newRmSubLotNo As String
Dim newReasCd As Nullable(Of Integer)
Dim newUserId As String
Dim newEntId As Nullable(Of Integer)
Dim newShiftId As Nullable(Of Integer)
Dim newToEntId As Nullable(Of Integer)
Dim newGenealogyId As String
Dim newEventId As String
Dim newSegmentRequirementId As String
Dim newSegmentResponseId As String
Dim newComments As String
Dim splitQtyProdErp As Nullable(Of Double)
Dim splitProcessedFlag As Nullable(Of Boolean)
Dim splitByproductFlag As Nullable(Of Boolean)
ItemProd.Split(sessionId, oldRowId, splitQtyProd, newWoId, newOperId, newSeqNo, newShiftStart, newItemId, newLotNo, newRmLotNo, newSubLotNo, newRmSubLotNo, newReasCd, newUserId, newEntId, newShiftId, newToEntId, newGenealogyId, newEventId, newSegmentRequirementId, newSegmentResponseId, newComments, splitQtyProdErp, splitProcessedFlag, splitByproductFlag)
public static void Split(
int sessionId,
int oldRowId,
double splitQtyProd,
string newWoId,
string newOperId,
Nullable<int> newSeqNo,
Nullable<DateTime> newShiftStart,
string newItemId,
string newLotNo,
string newRmLotNo,
string newSubLotNo,
string newRmSubLotNo,
Nullable<int> newReasCd,
string newUserId,
Nullable<int> newEntId,
Nullable<int> newShiftId,
Nullable<int> newToEntId,
string newGenealogyId,
string newEventId,
string newSegmentRequirementId,
string newSegmentResponseId,
string newComments,
Nullable<double> splitQtyProdErp,
Nullable<bool> splitProcessedFlag,
Nullable<bool> splitByproductFlag
)
Parameters
- sessionId
- Required. Holds the ID of the session from which the call is being made.
- oldRowId
- Required. Hold the row ID of the existing item production record whose production is being split.
- splitQtyProd
- Required. Holds the production quantity to be split. Must be less than or equal to the current quantity for the existing record.
- newWoId
- Optional. Holds the ID of the work order for the new job on which the split production was run. Defaults to the value in the existing record.
- newOperId
- Optional. Holds the ID of the operation for the new job on which the split production was run. Defaults to the value in the existing record.
- newSeqNo
- Optional. Holds the operation sequence number for the new job on which the split production was run. Defaults to the value in the existing record.
- newShiftStart
- Optional. Holds the date/time of the shift during which the split production occurred. Defaults to the value in the existing record.
- newItemId
- Optional. Holds the ID of the item produced in the new split job. Defaults to the value in the existing record.
- newLotNo
- Optional. Holds the lot number for the item produced in the new split job. Defaults to the value in the existing record.
- newRmLotNo
- Optional. Holds the lot number of the raw material from which the lot/sublot produced in the new split job was made. Defaults to the value in the existing record.
- newSubLotNo
- Optional. Holds the sublot number for the item produced in the new split job. Defaults to the value in the existing record.
- newRmSubLotNo
- Optional. Holds the sublot number of the raw material from which the lot/sublot produced in the new split job was made. Defaults to the value in the existing record.
- newReasCd
- Optional. Holds the reason code for the quantity produced in the new split job (production code or reject reason). Defaults to the value in the existing record.
- newUserId
- Optional. Holds the ID of the user responsible for the quantity produced in the new split job. Defaults to the value in the existing record.
- newEntId
- Optional. Holds the ID of the entity on which the split job was run. Defaults to the value in the existing record.
- newShiftId
- Optional. Holds the ID of the shift during which the split quantity was produced. Defaults to the value in the existing record.
- newToEntId
- Optional. Holds the ID of the storage entity for the split quantity. Defaults to the value in the existing record.
- newGenealogyId
- Optional. Holds the genealogy ID for the split quantity. Defaults to the value in the existing record.
- newEventId
- Optional. Holds the ID of the event for the split quantity. Defaults to the value in the existing record.
- newSegmentRequirementId
- Optional. Holds the segment requirement ID for the split quantity. Defaults to the value in the existing record.
- newSegmentResponseId
- Optional. Holds the segment response ID for the split quantity. Defaults to the value in the existing record.
- newComments
- Optional. Holds comments about the split quantity. Defaults to the value in the existing record.
- splitQtyProdErp
- Optional. Holds the split quantity value that has been reported to an ERP system. Defaults to the same ratio of qty_prod as in the existing record.
- splitProcessedFlag
- Optional. Holds a flag that specifies whether the split quantity was processed. Defaults to the value in the existing record.
- splitByproductFlag
- Optional. Holds a flag that specifies whether the split quantity is a by-product. Defaults to the value in the existing record.
The required fields identify the current record and the quantity to be split. The split quantity must be less than or equal to the qty_prod value in the existing record. (An equal quantity is equivalent to simply updating the existing row. All optional parameters default to the value in the existing row, except the splitQtyProdErp parameter, which defaults to the same percentage of qty_prod as in the existing record .
At least one of the new_* values that form the primary key must be specified to identify the destination record for the split. If a record already exists in the database for the split destination record, then the split quantity will simply be added to the existing record . If any other optional dependent fields are specified, then they will be changed for the split record . Note that this might overwrite existing dependent data for the destination record.
If the woId, operId, or seqNo change (i.e., indicating a new job), the corresponding job must exist for the method to succeed. If the newShiftStart value is specified, then the newShiftId must also be specified. No validation checks are done on these values.
If the newItemId value is specified, then it must exist in the database for the method to succeed.
If the newReasCd value is specified, then it must exist in the database for the method to succeed. If it exists, then it will be used to determine the gradeCd, statusCd, and goodProd flag for the split record. The ex_ref, move_status, and spare columns are set to the current values in the existing record. The last_edit_at column of the new record is set to the current date/time.