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

MES Stateless API

GetUnComplSNos(String,String,String,String,Int32,String,Boolean) Method

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

GetUnComplSNos(String,String,String,String,Int32,String,Boolean) Method

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

The GetUnComplSNos() method returns a list of uncompleted serial numbers for the specified item.

This overload of the method uses the entity name and site name to specify the entity.

Syntax

'Declaration
 
Public Overloads Shared Function GetUnComplSNos( _
   ByVal entName As String, _
   ByVal siteName As String, _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Integer, _
   ByVal itemId As String, _
   ByVal hardPegged As Boolean _
) As DataSet
'Usage
 
Dim entName As String
Dim siteName As String
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim itemId As String
Dim hardPegged As Boolean
Dim value As DataSet
 
value = JobExec.GetUnComplSNos(entName, siteName, woId, operId, seqNo, itemId, hardPegged)
public static DataSet GetUnComplSNos( 
   string entName,
   string siteName,
   string woId,
   string operId,
   int seqNo,
   string itemId,
   bool hardPegged
)

Parameters

entName
Required. Holds the name of the entity.
siteName
Optional. Holds the site name of the entity.
woId
Required. Holds the ID of the work order.
operId
Required. Holds the ID of the operation.
seqNo
Required. Holds the job sequence number.
itemId
Required. Holds the ID of the item.
hardPegged
Required. Holds a flag that, if set to true, specifies that this job is hard-pegged.

Return Value

Returns a DataSet that contains records for the uncompleted serial numbers that are found for the specified item. If no uncompleted serial numbers are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name

Description

serial_no

A string that is the lot number, from the Item_Prod, Item_Cons, Job_Step_Data, Item_Inv, and Job_Bom tables.

reas_cd

An integer that is the item reason code for this quantity produced (production code or reject production), from the Item_Prod table.

reas_desc

A string that is the description of the item reason, from the item_reas.reas_desc column linked to the reas_cd in the Item_Prod table.

qty_prod

A double that is the amount of quantity produced. This value is 0 if uncompleted.

Remarks

If the supplied value for hardPegged is true, then the serial numbers are retrieved as follows:

  • Those inventory located at the run-on entity or its immediate parent that have a work order matching that of the running job and an item matching the supplied item.
  • Those in the assigned lot table that are unstarted, that have an item matching the supplied item, and that are assigned to the current work order, and have either a null operation or an operation matching the current operation.
  • Those in inventory for the component part from which the serial number is to be inherited or its substitutes that are located at the run-on entity, its immediate parent, or the storage entity for that component (job_bom.def_storage_ent_id), that either have a null work order or one matching the current work order, and that do not match any serial number in the Assigned_Lot table.

If the supplied value for hardPegged is false (soft-pegged), then the serial numbers are retrieved as follows:

  • Those in the inventory located at the run-on entity or its immediate parent that have an item matching the supplied item regardless of the supplied work order
  • Those in the assigned lot table that are unstarted, that have an item matching that of the supplied item, that are assigned to the current work order, and have either a null operation or an operation matching the current operation
  • Those in inventory for the component part from which the serial number is to be inherited or its substitutes that are located at the run-on entity, its immediate parent, or the storage entity for that component (job_bom.def_storage_ent_id) and that do not match any serial number in the Assigned_Lot table.
In both hard-pegged and soft-pegged cases, if linear flow is enabled (i.e., wo.may_override_route is false), the set of serial numbers returned from inventory (case 1 and 3 above) that has a non-null work order will be limited to those produced on work orders that are also defined as having a linear flow and were produced at an operation whose ID is same as the one that is immediately upstream from the current operation. Only the serial numbers that are partially completed or uncompleted will be included in the DataSet.

See Also

Reference

JobExec Class
JobExec Members
Overload List

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