GetSrcInvLocs(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,String,Nullable<Int32>,String,String) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The GetSrcInvLocs() method retrieves a list of all entities, movable or non-movable, that contain inventory of serialized parts.
For this overload of the method, the optional entity filters are identified by their entity ID.
'Declaration
Public Overloads Shared Function GetSrcInvLocs( _
ByVal entId As Nullable(Of Integer), _
ByVal jobPos As Nullable(Of Integer), _
ByVal fromEntId As Nullable(Of Integer), _
ByVal itemId As String, _
ByVal serialNo As String, _
ByVal gradeCd As Nullable(Of Integer), _
ByVal woId As String, _
ByVal operId As String _
) As DataSet
'Usage
Dim entId As Nullable(Of Integer)
Dim jobPos As Nullable(Of Integer)
Dim fromEntId As Nullable(Of Integer)
Dim itemId As String
Dim serialNo As String
Dim gradeCd As Nullable(Of Integer)
Dim woId As String
Dim operId As String
Dim value As DataSet
value = StorageExec.GetSrcInvLocs(entId, jobPos, fromEntId, itemId, serialNo, gradeCd, woId, operId)
public static DataSet GetSrcInvLocs(
Nullable<int> entId,
Nullable<int> jobPos,
Nullable<int> fromEntId,
string itemId,
string serialNo,
Nullable<int> gradeCd,
string woId,
string operId
)
Parameters
- entId
- Optional filter parameter. Holds the ID of an entity by which to filter the locations being retrieved.
- jobPos
- Optional filter parameter. Holds a job position. If the value is > 1, this indicates that jobs are running on this entity.
- fromEntId
- Optional filter parameter. Holds the name of an entity to filter the retrieved locations by movable storage entities ultimately located at this entity.
- itemId
- Optional filter parameter. Holds the ID of an item.
- serialNo
- Optional filter parameter. Holds a serial number.
- gradeCd
- Optional filter parameter. Holds the code that identifies an item grade.
- woId
- Optional filter parameter. Holds a work order ID.
- operId
- Optional filter parameter. Holds an operation ID.
Return Value
Returns a DataSet that contains a record for each movable and/or non-movable entity that contains inventory of serialized items. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
ent_id |
An integer that is the ID of the entity, from the Storage_Exec.ent_id column that contains inventory of serialized parts. |
|
ent_name |
A string that is the name of the entity, from the ent.ent_name column linked to this entity (Storage_Exec.ent_id). |
For input parameters that are not to be included as a filter, pass a null.
If a non-null value for the work order parameter is supplied, then the entities retrieved will be limited to those directly containing inventory made by a job with this work order. If the work order contains a null value, and if the job is configured as hard-pegged job and the user does not have the privilege to override hard pegged and linear flow, the entities retrieved will be limited to those directly containing inventory that was not made by any work order.
If a non-null value for the operation is supplied, then the entities returned will be limited to those directly containing inventory made by a job with that operation. If the operation contains a null value, and if the job is configured as a hard pegged job and the user does not have the privilege to override hard pegged and linear flow, then the entities retrieved will be limited to those directly containing inventory that was not made by any operation.
If a non-null value is supplied for the item, then the entities retrieved will be limited to those directly containing this item. If a non-null grade code is supplied as filter, then the entities retrieved will be limited to those directly containing an item of this grade. Similarly, if the serial number is supplied as filter, then the entities retrieved will be limited to those directly containing inventory with serial numbers matching the supplied serial number.
If a non-null value for the from_entity is supplied, then the entities listed will be limited to movable storage entities ultimately located at that (non-movable) entity. This method returns a list of all entities identified by movable storage entity.
For each case above, if movable storage entities are included in the list, so are the non-movable storage entities at which they are ultimately located.