GetStorageLocations(Int32,String,String,Int64,Int64) Method
- Last UpdatedNov 06, 2025
- 2 minute read
The GetStorageLocations() method retrieves one or more storage records from the Ent table, as specified by the filter parameters. Passing no filter parameters will retrieve all storage records from the table.
If an entity that is running a job is configured as a non-movable entity, then it returns the list of entities that are eligible to send consumable items only. Any entities that are not eligible to send consumables are discarded. Conversely, if an entity that is running a job is configured as a movable entity, then it returns all the entities that are located at this Job_Exec entity. In addition to this, if the identified Job_Bom record is marked as WIP, then the intersection of Job_Exec entities and the storage locations from the previous job that produce the same item are only returned. On the other hand, if the WIP flag is turned off for the identified Job_Bom record, then all the eligible storage entities for a Job_Exec entity and all the the storage locations from the previous job that produce the same item are returned.
If optionally filtering the results by a specific entity, overload of the method specifies the entity by its supplied input parameters.
public static DataSet GetStorageLocations(
int entId,
string woId,
string operId,
long seqNo,
long bomPos
)
Parameters
- entId
- Required. Holds the entity on which the job is running.
- woId
- Required. Holds the ID of the work order of the job.
- operId
- Required. Holds the ID of the operation of the job.
- seqNo
- Required. Holds the sequence number of the job.
- bomPos
- Required. Holds the BOM position of the item being consumed.
Return Value
Returns a DataSet that contains records for all the storages that satisfy the specified filters. The returned records include columns from the Job_Exec, and Job_Bom tables. If no matching staorages are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.