Update Method (JobBomSubstitute)

• Visual Basic
• C#

'Declaration
 
Public Shared Sub Update( _
   ByVal sessionId As Integer, _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Integer, _
   ByVal bomPos As Integer, _
   ByVal altNo As Integer, _
   ByVal pref As Integer, _
   ByVal substLevel As Integer, _
   ByVal itemId As String, _
   ByVal reqdGradeCd As DBInt, _
   ByVal instruction As DBString, _
   ByVal qtyPerParentItem As Double, _
   ByVal maxQtyPerParentItem As DBDouble, _
   ByVal minQtyPerParentItem As DBDouble, _
   ByVal reqdStartVal As Double, _
   ByVal reqdStartValIsPct As Boolean, _
   ByVal updateInv As Boolean, _
   ByVal backflush As Boolean, _
   ByVal defReasCd As DBInt, _
   ByVal defLotNo As DBString, _
   ByVal defStorageEntId As DBInt, _
   ByVal defRejectEntId As DBInt, _
   ByVal scalingFactor As DBDouble, _
   ByVal mustConsumeFromInv As Boolean, _
   ByVal mayChooseAltInvLoc As Boolean, _
   ByVal mayCreateNewLots As Boolean, _
   ByVal mustConsumeFromWip As Boolean, _
   ByVal mustConsumeBeforeProd As Boolean, _
   ByVal constantQty As Boolean, _
   ByVal estTime As DBDouble, _
   ByVal spare1 As DBString, _
   ByVal spare2 As DBString, _
   ByVal spare3 As DBString, _
   ByVal spare4 As DBString, _
   ByVal lastEditComment As DBString, _
   ByRef lastEditAt As Date _
) 

'Usage
 
Dim sessionId As Integer
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim bomPos As Integer
Dim altNo As Integer
Dim pref As Integer
Dim substLevel As Integer
Dim itemId As String
Dim reqdGradeCd As DBInt
Dim instruction As DBString
Dim qtyPerParentItem As Double
Dim maxQtyPerParentItem As DBDouble
Dim minQtyPerParentItem As DBDouble
Dim reqdStartVal As Double
Dim reqdStartValIsPct As Boolean
Dim updateInv As Boolean
Dim backflush As Boolean
Dim defReasCd As DBInt
Dim defLotNo As DBString
Dim defStorageEntId As DBInt
Dim defRejectEntId As DBInt
Dim scalingFactor As DBDouble
Dim mustConsumeFromInv As Boolean
Dim mayChooseAltInvLoc As Boolean
Dim mayCreateNewLots As Boolean
Dim mustConsumeFromWip As Boolean
Dim mustConsumeBeforeProd As Boolean
Dim constantQty As Boolean
Dim estTime As DBDouble
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
 
JobBomSubstitute.Update(sessionId, woId, operId, seqNo, bomPos, altNo, pref, substLevel, itemId, reqdGradeCd, instruction, qtyPerParentItem, maxQtyPerParentItem, minQtyPerParentItem, reqdStartVal, reqdStartValIsPct, updateInv, backflush, defReasCd, defLotNo, defStorageEntId, defRejectEntId, scalingFactor, mustConsumeFromInv, mayChooseAltInvLoc, mayCreateNewLots, mustConsumeFromWip, mustConsumeBeforeProd, constantQty, estTime, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)

public static void Update( 
   int sessionId,
   string woId,
   string operId,
   int seqNo,
   int bomPos,
   int altNo,
   int pref,
   int substLevel,
   string itemId,
   DBInt reqdGradeCd,
   DBString instruction,
   double qtyPerParentItem,
   DBDouble maxQtyPerParentItem,
   DBDouble minQtyPerParentItem,
   double reqdStartVal,
   bool reqdStartValIsPct,
   bool updateInv,
   bool backflush,
   DBInt defReasCd,
   DBString defLotNo,
   DBInt defStorageEntId,
   DBInt defRejectEntId,
   DBDouble scalingFactor,
   bool mustConsumeFromInv,
   bool mayChooseAltInvLoc,
   bool mayCreateNewLots,
   bool mustConsumeFromWip,
   bool mustConsumeBeforeProd,
   bool constantQty,
   DBDouble estTime,
   DBString spare1,
   DBString spare2,
   DBString spare3,
   DBString spare4,
   DBString lastEditComment,
   ref DateTime lastEditAt
)

Parameters

sessionId

Required. Holds the session ID and thus the user who is making this method call.

woId

Required. Holds the ID of the work order for the job.

operId

Required. Holds the ID of the operation for the job.

seqNo

Required. Holds the operation sequence number of the job.

bomPos

Required. Holds the BOM position.

altNo

Required. Holds the alternative for the given BOM position.

pref

Required. Holds the preference that specifies the lower numbered alternatives are preferable than the higher numbered ones.

substLevel

Required. Holds an integer that acts as a substitution privilege level, so that a user has to have this substituion level to be able to substitute the BOM item. The default is 0, which means anyone can use this substitute.

itemId

Required. Holds the ID of the substitute item being produced or consumed.

reqdGradeCd

Required. Holds the required grade code for the BOM item.

instruction

Required. Holds the instructions on how to consume or produce this item.

qtyPerParentItem

Required. Holds the nominal quantity of the item required per unit of the parent item.

maxQtyPerParentItem

Required. Holds the maximum acceptable quantity of this BOM component.

minQtyPerParentItem

Required. Holds the minimum acceptable quantity of this BOM component.

reqdStartVal

Required. Holds the amount of the component required before running the job. The default is zero.

reqdStartValIsPct

Required. Holds a flag that, if set to true or false, specifies that the required start value is a percentage and, if set to false, specifies that the required start value is an absolute quantity. The default is true.

updateInv

Required. Holds a flag that, if set to true, specifies that the inventory table is updated with consumed items. The default is false.

backflush

Required. Holds a flag that, if set to true, specifies that consumption is backflushed. The default is false.

defReasCd

Required. Holds the ID of the default item reason code.

defLotNo

Required. Holds the default lot number of the item.

defStorageEntId

Required. Holds the default storage entity for the item or the by-product.

defRejectEntId

Required. Holds the ID of the default storage entity for the rejected production items. If null, the def_storage_ent_id is used.

scalingFactor

Required. Holds the number that specifies the scaling factor, which is used to get the correct units from counts if the counts are item dependent. The default is 1.

mustConsumeFromInv

Required. Holds a flag that, if set to true, specifies that consumption must occur from the inventory for this item. The default is false.

mayChooseAltInvLoc

Required. Holds a flag that, if set to true, specifies that the user can select alternate inventory locations when consuming or producing this item. The default is true.

mayCreateNewLots

Required. Holds a flag that, if set to true, specifies that the user can create new lots when consuming or producing this item. The default is true.

mustConsumeFromWip

Required. Holds a flag that, if set to true, specifies that the lots consumed during the job are limited to the lots produced to the Item_Inv table for the same work order in an upstream job. The default is false.

mustConsumeBeforeProd

Required. Holds a flag that, if set to true, specifies that the production transactions are prevented until 'acceptable' quantities of BOM components are consumed, as specified in the maxQtyPerParentItem and minQtyPerParentItemparameters. The default is false.

constantQty

Required. Holds a flag that, if set to true, specifies that the quantity of the consumed item is independent of the quantity of the parent item that is produced. The default is false.

estTime

Required. Holds the number of hours it should take to consume or produce the component per unit of BOM position zero. If null, the BOM position is zero.

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 describe why this record is being updated.

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.