Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

MES Stateless API

AddConsPostExec(Int32,String,Double,Nullable<Int32>,String,String,Nullable<Int32>,Nullable<DateTime>,Nullable<Int32>,Nullable<Int32>,String,Nullable<Int32>,String,String,String,String,Nullable<Int32>,String,String,String,String,String,String,DBString,DBString,DBString,DBString,Nullable<Int32>) Method

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
TABLE OF CONTENTS

AddConsPostExec(Int32,String,Double,Nullable<Int32>,String,String,Nullable<Int32>,Nullable<DateTime>,Nullable<Int32>,Nullable<Int32>,String,Nullable<Int32>,String,String,String,String,Nullable<Int32>,String,String,String,String,String,String,DBString,DBString,DBString,DBString,Nullable<Int32>) Method

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL

The AddConsPostExec() method enters consumption data for a given job, shift, production code, lot, and container in the consumption transaction table (Item_Cons) after the job has run on an entity. This method can add a new Item_Cons record or update an existing record.

This overload of the method uses the entity ID to identify entities specified for the method.

Syntax

'Declaration
 
Public Overloads Shared Sub AddConsPostExec( _
   ByVal sessionId As Integer, _
   ByVal userId As String, _
   ByVal qtyCons As Double, _
   ByVal entId As Nullable(Of Integer), _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Nullable(Of Integer), _
   ByVal shiftStart As Nullable(Of Date), _
   ByVal shiftId As Nullable(Of Integer), _
   ByVal bomPos As Nullable(Of Integer), _
   ByVal itemId As String, _
   ByVal reasCd As Nullable(Of Integer), _
   ByVal lotNo As String, _
   ByVal fgLotNo As String, _
   ByVal subLotNo As String, _
   ByVal fgSubLotNo As String, _
   ByVal fromEntId As Nullable(Of Integer), _
   ByVal extRef As String, _
   ByVal genealogyId As String, _
   ByVal upstreamEventId As String, _
   ByVal segmentRequirementId As String, _
   ByVal segmentResponseId As String, _
   ByVal comments As String, _
   ByVal spare1 As DBString, _
   ByVal spare2 As DBString, _
   ByVal spare3 As DBString, _
   ByVal spare4 As DBString, _
   ByVal rowId As Nullable(Of Integer) _
) 
'Usage
 
Dim sessionId As Integer
Dim userId As String
Dim qtyCons As Double
Dim entId As Nullable(Of Integer)
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim shiftStart As Nullable(Of Date)
Dim shiftId As Nullable(Of Integer)
Dim bomPos As Nullable(Of Integer)
Dim itemId As String
Dim reasCd As Nullable(Of Integer)
Dim lotNo As String
Dim fgLotNo As String
Dim subLotNo As String
Dim fgSubLotNo As String
Dim fromEntId As Nullable(Of Integer)
Dim extRef As String
Dim genealogyId As String
Dim upstreamEventId As String
Dim segmentRequirementId As String
Dim segmentResponseId As String
Dim comments As String
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim rowId As Nullable(Of Integer)
 
JobExec.AddConsPostExec(sessionId, userId, qtyCons, entId, woId, operId, seqNo, shiftStart, shiftId, bomPos, itemId, reasCd, lotNo, fgLotNo, subLotNo, fgSubLotNo, fromEntId, extRef, genealogyId, upstreamEventId, segmentRequirementId, segmentResponseId, comments, spare1, spare2, spare3, spare4, rowId)
public static void AddConsPostExec( 
   int sessionId,
   string userId,
   double qtyCons,
   Nullable<int> entId,
   string woId,
   string operId,
   Nullable<int> seqNo,
   Nullable<DateTime> shiftStart,
   Nullable<int> shiftId,
   Nullable<int> bomPos,
   string itemId,
   Nullable<int> reasCd,
   string lotNo,
   string fgLotNo,
   string subLotNo,
   string fgSubLotNo,
   Nullable<int> fromEntId,
   string extRef,
   string genealogyId,
   string upstreamEventId,
   string segmentRequirementId,
   string segmentResponseId,
   string comments,
   DBString spare1,
   DBString spare2,
   DBString spare3,
   DBString spare4,
   Nullable<int> rowId
)

Parameters

sessionId
Required. Holds the session ID and thus the user who is making this method call.
userId
Required. Holds the ID of the user to whom to attribute consumption.
qtyCons
Required. Holds the quantity being consumed.
entId
Optional. Holds the ID of the entity.
woId
Optional. Holds the ID of the work order.
operId
Optional. Holds the ID of the operation.
seqNo
Optional. Holds the job sequence number.
shiftStart
Optional. Holds the shift start.
shiftId
Optional. Holds the ID of the shift on the entity.
bomPos
Optional. Holds the BOM position of the item being consumed.
itemId
Optional. Holds the ID of the item being consumed.
reasCd
Optional. Holds the reason code for item being consumed.
lotNo
Optional. Holds the lot number of the item being consumed.
fgLotNo
Optional. Holds the finished goods lot number of the item being consumed.
subLotNo
Optional. Holds the sublot number of the item being consumed.
fgSubLotNo
Optional. Holds the finished goods sublot number of the item being consumed.
fromEntId
Optional. Holds the ID of the storage entity.
extRef
Optional. Holds the external reference of the item being consumed.
genealogyId
Optional. Holds the genealogy ID (for S95).
upstreamEventId
Optional. Holds the upstream event ID (for S95).
segmentRequirementId
Optional. Holds the segment requirement ID (for S95).
segmentResponseId
Optional. Holds the segment response ID (for S95).
comments
Optional. Holds comments about the consumption that is being added.
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.
rowId

Optional. Holds the row ID of the record in the Item_Cons table to be updated. See Remarks below.

Remarks

The low number of required parameters for this method are designed to facilitate capturing consumption data from the I/O system via tags as simply as possible.

Determining the Shift Start Time

To determine the shift_start_utc time for the new or updated record, the system first uses the supplied shiftStart value, converting the local time to UTC. If a shiftStart value is not supplied, then it uses the current shift's start time.

Determining Whether an Item_Cons Record Is Updated or Added

  • If a matching Item_Cons record is found, that record is updated with the values supplied in the call.
  • If a matching Item_Cons record is not found or the Maintain distinct consumption records system attribute is True, then a new record is created with the values supplied in the call.

A matching record is found based on either of the following conditions:

  • The rowId is the actual primary key for the Item_Cons table. If a value for it is supplied and a matching record is found, then that record is updated with the other input parameter values supplied in the call.
  • A rowId is not supplied or found but all of the supplied values for the following effective primary key fields match those of an existing Item_Cons record:
    • shift_start_utc (determined as described above)
    • wo_id (cannot be null)
    • oper_id (cannot be null)
    • seq_no (cannot be null)
    • item_id (cannot be null)
    • lot_no (can be null, but the existing record’s value must also be null)
    • fg_lot_no (can be null, but the existing record’s value must also be null)
    • sublot_no (can be null, but the existing record’s value must also be null)
    • reas_cd (cannot be null)
    • user_id (cannot be null)
    • genealogy_id (can be null, but the existing record’s value must also be null)
    • upstream_event_id (can be null, but the existing record’s value must also be null)
    • segment_requirement_id (can be null, but the existing record’s value must also be null)
    • segment_response_id (can be null, but the existing record’s value must also be null)

Other Behaviors of This Method

  • If the work order details are not provided, they default to the current job running on the entity.
  • If any of the lot, container, reason code, or entity values change, then these changes are written to the Job_Bom table and used as the defaults for future transactions where the defaults are to be applied.
  • If the fg_lot_no column changes, then this change is remembered for the item being produced. This is as if the lot number was changed using the AddProd() or SetCurProdData() methods.
  • If the update_inv flag is set for this BOM position, then the qty_left column in the Item_Inv record will be reduced by the consumed qty_cons.

Input Parameter Rules

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.

See Also

Reference

JobExec Class
JobExec Members
Overload List

In This Topic
TitleResults for “How to create a CRG?”Also Available in