Update(Int32,String,String,Int32,DBString,String,Int32,Int32,DBDateTime,Int32,Int32,DBInt,Double,Double,DBDouble,Double,DBDouble,Double,Double,Double,Double,Boolean,Boolean,DBDouble,DBDouble,DBDouble,DBDouble,Double,Int32,DBDouble,DBDateTime,DBDateTime,DBDateTime,DBDateTime,DBDateTime,Int32,DBDouble,Boolean,Boolean,DBString,DBString,DBString,DBString,Int32,DBString,Boolean,DBString,DBString,DBString,DBString,DBString,DBString,DBString,DateTime) Method
- Last UpdatedNov 06, 2025
- 7 minute read
The Update() method updates all columns for the specified job record in the Job table.
'Declaration
Public Overloads Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Integer, _
ByVal jobDesc As DBString, _
ByVal itemId As String, _
ByVal stateCd As Integer, _
ByVal jobPriority As Integer, _
ByVal reqFinishTimeLocal As DBDateTime, _
ByVal initSchedEntId As Integer, _
ByVal targetSchedEntId As Integer, _
ByVal runEntId As DBInt, _
ByVal qtyReqd As Double, _
ByVal qtyProd As Double, _
ByVal qtyProdErp As DBDouble, _
ByVal qtyRejected As Double, _
ByVal qtyRejectedErp As DBDouble, _
ByVal qtyAtStart As Double, _
ByVal deviationAbove As Double, _
ByVal deviationBelow As Double, _
ByVal batchSize As Double, _
ByVal schedPinned As Boolean, _
ByVal checkInv As Boolean, _
ByVal estFixedLab As DBDouble, _
ByVal estLabRate As DBDouble, _
ByVal estSetupTime As DBDouble, _
ByVal estTeardownTime As DBDouble, _
ByVal estProdRate As Double, _
ByVal prodUom As Integer, _
ByVal estTransferTime As DBDouble, _
ByVal schedStartTimeLocal As DBDateTime, _
ByVal latestStartTimeLocal As DBDateTime, _
ByVal schedFinishTimeLocal As DBDateTime, _
ByVal actStartTimeLocal As DBDateTime, _
ByVal actFinishTimeLocal As DBDateTime, _
ByVal concurrentLink As Integer, _
ByVal jobCost As DBDouble, _
ByVal parentContingentJob As Boolean, _
ByVal childContingentJob As Boolean, _
ByVal notes As DBString, _
ByVal assocFile As DBString, _
ByVal assocFileType As DBString, _
ByVal statusNotes As DBString, _
ByVal displaySeq As Integer, _
ByVal folderVerId As DBString, _
ByVal rework As Boolean, _
ByVal reworkCd As DBString, _
ByVal reworkProcessId As DBString, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef editTime As Date _
)
'Usage
Dim sessionId As Integer
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim jobDesc As DBString
Dim itemId As String
Dim stateCd As Integer
Dim jobPriority As Integer
Dim reqFinishTimeLocal As DBDateTime
Dim initSchedEntId As Integer
Dim targetSchedEntId As Integer
Dim runEntId As DBInt
Dim qtyReqd As Double
Dim qtyProd As Double
Dim qtyProdErp As DBDouble
Dim qtyRejected As Double
Dim qtyRejectedErp As DBDouble
Dim qtyAtStart As Double
Dim deviationAbove As Double
Dim deviationBelow As Double
Dim batchSize As Double
Dim schedPinned As Boolean
Dim checkInv As Boolean
Dim estFixedLab As DBDouble
Dim estLabRate As DBDouble
Dim estSetupTime As DBDouble
Dim estTeardownTime As DBDouble
Dim estProdRate As Double
Dim prodUom As Integer
Dim estTransferTime As DBDouble
Dim schedStartTimeLocal As DBDateTime
Dim latestStartTimeLocal As DBDateTime
Dim schedFinishTimeLocal As DBDateTime
Dim actStartTimeLocal As DBDateTime
Dim actFinishTimeLocal As DBDateTime
Dim concurrentLink As Integer
Dim jobCost As DBDouble
Dim parentContingentJob As Boolean
Dim childContingentJob As Boolean
Dim notes As DBString
Dim assocFile As DBString
Dim assocFileType As DBString
Dim statusNotes As DBString
Dim displaySeq As Integer
Dim folderVerId As DBString
Dim rework As Boolean
Dim reworkCd As DBString
Dim reworkProcessId As DBString
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim editTime As Date
Job.Update(sessionId, woId, operId, seqNo, jobDesc, itemId, stateCd, jobPriority, reqFinishTimeLocal, initSchedEntId, targetSchedEntId, runEntId, qtyReqd, qtyProd, qtyProdErp, qtyRejected, qtyRejectedErp, qtyAtStart, deviationAbove, deviationBelow, batchSize, schedPinned, checkInv, estFixedLab, estLabRate, estSetupTime, estTeardownTime, estProdRate, prodUom, estTransferTime, schedStartTimeLocal, latestStartTimeLocal, schedFinishTimeLocal, actStartTimeLocal, actFinishTimeLocal, concurrentLink, jobCost, parentContingentJob, childContingentJob, notes, assocFile, assocFileType, statusNotes, displaySeq, folderVerId, rework, reworkCd, reworkProcessId, spare1, spare2, spare3, spare4, lastEditComment, editTime)
public static void Update(
int sessionId,
string woId,
string operId,
int seqNo,
DBString jobDesc,
string itemId,
int stateCd,
int jobPriority,
DBDateTime reqFinishTimeLocal,
int initSchedEntId,
int targetSchedEntId,
DBInt runEntId,
double qtyReqd,
double qtyProd,
DBDouble qtyProdErp,
double qtyRejected,
DBDouble qtyRejectedErp,
double qtyAtStart,
double deviationAbove,
double deviationBelow,
double batchSize,
bool schedPinned,
bool checkInv,
DBDouble estFixedLab,
DBDouble estLabRate,
DBDouble estSetupTime,
DBDouble estTeardownTime,
double estProdRate,
int prodUom,
DBDouble estTransferTime,
DBDateTime schedStartTimeLocal,
DBDateTime latestStartTimeLocal,
DBDateTime schedFinishTimeLocal,
DBDateTime actStartTimeLocal,
DBDateTime actFinishTimeLocal,
int concurrentLink,
DBDouble jobCost,
bool parentContingentJob,
bool childContingentJob,
DBString notes,
DBString assocFile,
DBString assocFileType,
DBString statusNotes,
int displaySeq,
DBString folderVerId,
bool rework,
DBString reworkCd,
DBString reworkProcessId,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref DateTime editTime
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- woId
- Required. Holds the work order for the job.
- operId
- Required. Holds the ID of the operation for the job.
- seqNo
- Required. Holds the operation sequence number.
- jobDesc
- Required. Holds the description of the job.
- itemId
- Required. Holds the ID of the item resulting from this job.
- stateCd
- Required. Holds an integer that identifies the job state.
- jobPriority
- Required. Holds the operation priority.
- reqFinishTimeLocal
- Required. Holds the required completion date/time in the entity's local time.
- initSchedEntId
- Required. Holds the ID of the entity to which the job is initially scheduled.
- targetSchedEntId
- Required. Holds the ID of the entity to which job is actually scheduled.
- runEntId
- Required. Holds the ID of the entity on which the job is actually run.
- qtyReqd
- Required. Holds the required quantity of the item.
- qtyProd
- Required. Holds the quantity of the item produced so far.
- qtyProdErp
- Required. Holds the quantity produced as uploaded to ERP.
- qtyRejected
- Required. Holds the quantity of the item rejected so far.
- qtyRejectedErp
- Required. Holds the quantity rejected as uploaded to ERP.
- qtyAtStart
- Required. Holds the quantity expected to be produced if there are no scrap/waste/rejects.
- deviationAbove
- Required. Holds the portion of the start quantity by which total production can deviate above.
- deviationBelow
- Required. Holds the portion of start quantity by which total production can deviate below.
- batchSize
- Required. Holds the amount of product per batch.
- schedPinned
- Required. Holds a flag that, if set to true, specifies that the start time is fixed and can not be changed.
- checkInv
- Required. Holds a flag that, if set to true, specifies that sufficient component inventory is required to change the state to ‘Ready’.
- estFixedLab
- Required. Holds the estimated fixed labor hours for setup and cleanup.
- estLabRate
- Required. Holds the estimated variable labor batch time, depending on the production unit of measure (prod_uom).
- estSetupTime
- Required. Holds the estimated entity hours for setup.
- estTeardownTime
- Required. Holds the estimated entity hours for teardown.
- estProdRate
- Required. Holds the estimated entity batch rate or time, depending on the production unit of measure (prod_uom).
- prodUom
Required. Holds an enumeration that specifies the unit of measure for est_lab_rate and est_prod_rate.
0 = Hours per batch
1 = Minutes per batch
2 = Seconds per batch
3 = Batches per hour
4 = Batches per minute
5 = Batches per second
- estTransferTime
- Required. Holds the transfer time (in hours) after the operation.
- schedStartTimeLocal
- Required. Holds the scheduled start time in the entity's local time.
- latestStartTimeLocal
- Required. Holds the latest start time in the entity's local time to meet the required finish time.
- schedFinishTimeLocal
- Required. Holds the estimated completion time in the entity's local time.
- actStartTimeLocal
- Required. Holds the actual start time in the entity's local time.
- actFinishTimeLocal
- Required. Holds the actual completion time in the entity's local time.
- concurrentLink
- Required. Holds an integer used to match up concurrent jobs.
- jobCost
- Required. Holds additional (i.e., non-labor, non-machine, and non-material) cost associated specifically with this job.
- parentContingentJob
- Required. Holds a flag that, if set to true, specifies that this job is for a group that will really be run on one or more children.
- childContingentJob
- Required. Holds a flag that, if set to true, specifies that this is a potential job for one of a group of entities.
- notes
- Required. Holds specific notes for this job, typically for the operator to read.
- assocFile
- Required. Holds the path and file name of the file associated with the job.
- assocFileType
- Required. Holds the file type of the file associated with the job.
- statusNotes
- Required. Holds notes regarding job status; typically operator-entered (e.g., when suspending the job).
- displaySeq
- Required. An integer specifying the sequence of jobs independently of the operation ID. Used to sequence jobs in trees and flow diagrams.
- folderVerId
- Required. Holds an optional link to specify a folder version for this job.
- rework
- Required. Holds a flag that, if set to true, specifies that this job has required or does require rework.
- reworkCd
- Required. Holds an integer specifying the rework behavior of this job.
- reworkProcessId
- Required. Holds the process id of the rework process this job was created from.
- 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 changed.
- editTime
Required. Holds the date/time when this record was added or last edited, for optimistic concurrency control. The passed value must match the editTimevalue in the record for the update to succeed.
Output. Holds the date/time value when the record was updated by this called method.