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

MES Stateless API

TABLE OF CONTENTS

GetJobRoute Method

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

The GetJobRoute() method retrieves a list of jobs for the specified work order, in the order in which they are defined to be displayed on the job route diagram.

Syntax

'Declaration
 
Public Shared Function GetJobRoute( _
   ByVal woId As String _
) As DataSet
'Usage
 
Dim woId As String
Dim value As DataSet
 
value = JobRoute.GetJobRoute(woId)
public static DataSet GetJobRoute( 
   string woId
)

Parameters

woId
Required. Holds the work order ID of the jobs that are being retrieved.

Return Value

Returns a DataSet that contains all the the job records in the Job table for the specified work order, in the order in which they are defined to be displayed on the job route diagram. If no matching records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name

Description

wo_id

A string that is the work order ID of the job.

oper_id

A string that is the operation ID of the job.

seq_no

An integer that is the operation sequence number of the job.

run_ent_id

An integer that is the ID of the entity on which the job is actually run. The value is null if the job has not been started yet.

run_ent_name

A string that is the name of the entity on which the job is actually run, from the Ent table. The value is null if the job has not been started yet.

qty_prod

A double that is the quantity of the item made so far. The default is 0.

qty_reqd

A double that is the quantity of the item that is required.

target_sched_ent_id

An integer that is the ID of the entity to which the job is actually scheduled.

target_sched_ent_name

A string that is the name of the entity to which the job is actually scheduled, from the Ent table.

state_cd

An integer that is the current job state of the job. The default = 1 for New.

color

An integer that represents the RGB background color used to represent a job state, from the Job_State table.

display_seq

An integer that specifies the sequence of jobs independently of oper_id. It is used to sequence jobs in a tree or flow diagram.

See Also

Reference

JobRoute Class
JobRoute Members

In This Topic