MES Stateless API

GetAll Method (ItemTransfer)

Save PDF

GetAll Method (ItemTransfer)

Save PDF

Last UpdatedNov 06, 2025
8 minute read

The GetAll() method retrieves one or more item transfer records from the Item_Transfer table, as specified by the filter parameters. Passing no filter parameters will retrieve all item transfer records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Nullable(Of Integer), _
   ByVal bomPos As Nullable(Of Integer), _
   ByVal toEntId As Nullable(Of Integer), _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal subLotNo As String, _
   ByVal gradeCd As Nullable(Of Integer), _
   ByVal statusCd As Nullable(Of Integer), _
   ByVal expiryDate As Nullable(Of Date), _
   ByVal fromWoId As String, _
   ByVal fromOperId As String, _
   ByVal fromSeqNo As Nullable(Of Integer), _
   ByVal fromEntId As Nullable(Of Integer), _
   ByVal fromItemId As String, _
   ByVal fromLotNo As String, _
   ByVal fromSubLotNo As String, _
   ByVal fromGradeCd As Nullable(Of Integer), _
   ByVal fromStatusCd As Nullable(Of Integer), _
   ByVal fromExpiryDate As Nullable(Of Date), _
   ByVal goodsReceived As Nullable(Of Boolean), _
   ByVal goodsShipped As Nullable(Of Boolean), _
   ByVal transferBy As String, _
   ByVal transferTimeUtc As Nullable(Of Date), _
   ByVal transferTimeLocal As Nullable(Of Date), _
   ByVal transId As Nullable(Of Integer) _
) As DataSet

'Usage
 
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim bomPos As Nullable(Of Integer)
Dim toEntId As Nullable(Of Integer)
Dim itemId As String
Dim lotNo As String
Dim subLotNo As String
Dim gradeCd As Nullable(Of Integer)
Dim statusCd As Nullable(Of Integer)
Dim expiryDate As Nullable(Of Date)
Dim fromWoId As String
Dim fromOperId As String
Dim fromSeqNo As Nullable(Of Integer)
Dim fromEntId As Nullable(Of Integer)
Dim fromItemId As String
Dim fromLotNo As String
Dim fromSubLotNo As String
Dim fromGradeCd As Nullable(Of Integer)
Dim fromStatusCd As Nullable(Of Integer)
Dim fromExpiryDate As Nullable(Of Date)
Dim goodsReceived As Nullable(Of Boolean)
Dim goodsShipped As Nullable(Of Boolean)
Dim transferBy As String
Dim transferTimeUtc As Nullable(Of Date)
Dim transferTimeLocal As Nullable(Of Date)
Dim transId As Nullable(Of Integer)
Dim value As DataSet
 
value = ItemTransfer.GetAll(woId, operId, seqNo, bomPos, toEntId, itemId, lotNo, subLotNo, gradeCd, statusCd, expiryDate, fromWoId, fromOperId, fromSeqNo, fromEntId, fromItemId, fromLotNo, fromSubLotNo, fromGradeCd, fromStatusCd, fromExpiryDate, goodsReceived, goodsShipped, transferBy, transferTimeUtc, transferTimeLocal, transId)

public static DataSet GetAll( 
   string woId,
   string operId,
   Nullable<int> seqNo,
   Nullable<int> bomPos,
   Nullable<int> toEntId,
   string itemId,
   string lotNo,
   string subLotNo,
   Nullable<int> gradeCd,
   Nullable<int> statusCd,
   Nullable<DateTime> expiryDate,
   string fromWoId,
   string fromOperId,
   Nullable<int> fromSeqNo,
   Nullable<int> fromEntId,
   string fromItemId,
   string fromLotNo,
   string fromSubLotNo,
   Nullable<int> fromGradeCd,
   Nullable<int> fromStatusCd,
   Nullable<DateTime> fromExpiryDate,
   Nullable<bool> goodsReceived,
   Nullable<bool> goodsShipped,
   string transferBy,
   Nullable<DateTime> transferTimeUtc,
   Nullable<DateTime> transferTimeLocal,
   Nullable<int> transId
)

Parameters

woId: Optional filter parameter. Holds the work order ID for a job for which transfer occurred while recording an allocation. If the producing job is changed, the woId parameter specifies the work order ID by which the inventory was produced.
operId: Optional filter parameter. Holds the ID of the operation for a job. If the producing job is changed, the operId parameter specifies the new operation ID by which the inventory was produced.
seqNo: Optional filter parameter. Holds the sequence number for an operation. If the producing job is changed, the seqNo parameter specifies the new sequence number by which the inventory was produced.
bomPos: Optional filter parameter. Holds the BOM position of an item being transferred.
toEntId: Optional filter parameter. Holds the ID of a destination storage entity.
itemId: Optional filter parameter. Holds the ID of an item being transferred.
lotNo: Optional filter parameter. Holds the lot number of an item being transferred.
subLotNo: Optional filter parameter. Holds the sublot number of an item being transferred.
gradeCd: Optional filter parameter. Holds the grade code of a material being transferred.
statusCd: Optional filter parameter. Holds the status code of a material that is being transferred.
expiryDate: Optional filter parameter. Holds the expiry date and time for the item at the destination storage entity in the local time of that entity.
fromWoId: Optional filter parameter. Holds the ID of a work order for producing the inventory.
fromOperId: Optional filter parameter. Holds the ID of an operation for producing inventory.
fromSeqNo: Optional filter parameter. Holds a sequence number for producing inventory.
fromEntId: Optional filter parameter. Holds the ID of an entity from which the transfer occurs.
fromItemId: Optional filter parameter. Holds the ID of an item that is transferred from the old location.
fromLotNo: Optional filter parameter. Holds a lot number of an item that is transferred from the old location.
fromSubLotNo: Optional filter parameter. Holds a sublot number of an item that is transferred from the old location.
fromGradeCd: Optional filter parameter. Holds the grade code of the items at the old location.
fromStatusCd: Optional filter parameter. Holds the status code of the items at the old location.
fromExpiryDate: Optional filter parameter. Holds the inventory's expiry date and time at the source storage entity in the local time of that entity.
goodsReceived: Optional filter parameter. Holds a flag that specifies whether the goods are received from the supplier.
goodsShipped: Optional filter parameter. Holds a flag that specifies whether the goods are shipped to the customer.
transferBy: Optional filter parameter. Holds the ID of a user who made a transfer.
transferTimeUtc: Optional filter parameter. Holds the time when the item transfer occurred, in UTC.
transferTimeLocal: Optional filter parameter. Holds the time when the transfer occurred in the local time of the destination storate entity.
transId: Optional filter parameter. Holds the ID of an item transfer.

Return Value

Returns a DataSet that contains records for all the item transfers that satisfy the specified filters. The returned records include columns from the Ent, Item, and Item_Inv tables. If no matching item transfers 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 for which the transfer occurred.
oper_id	A string that is the operation ID of the job for which the transfer occurred .
seq_no	A number that is the sequence number of the job for which the transfer occurred.
bom_pos	An integer that is the BOM position for which the transfer occurred.
to_ent_id	An integer that is the ID of the destination storage entity.
to_ent_name	A string that is the name of the destination storage entity.
ent_name	A string that is the name of the Ent table in the destination storage entity.
item_id	A string that is the ID of the item being transferred.
item_desc	A string that is the description of the item being transferred.
lot_no	A string that is the lot number of the item at the new location.
sublot_no	A string that is sublot number of the item at the new location.
grade_cd	An integer that is the grade code of the material being transferred.
status_cd	An integer that is the status code of the material being transferred.
qty_txd	A floating point number that is the quantity being transferred.
uom_id	An integer that is the ID of the unit of measure for the item at the new location.
expiry_date_utc	A datetime that is the expiry date and time for the inventory at the new location in UTC, from the Item_Inv table.
expiry_date_local	A datetime that is the expiry date and time for the inventory at the new location in the local time of the new location entity, from the Item_Inv table.
expiry_date	A datetime that is the expiry date and time for the inventory at the new location in the local time of the client application that is making the call, converted from the expiry_date_utc value.
to_spare1	A string that is the contents of the user-defined to_spare1 field.
to_spare2	A string that is the contents of the user-defined to_spare2 field.
to_spare3	A string that is the contents of the user-defined to_spare3 field.
to_spare4	A string that is the contents of the user-defined to_spare4 field.
to_spare5	A string that is the contents of the user-defined to_spare5 field.
to_spare6	A string that is the contents of the user-defined to_spare6 field.
from_wo_id	A string that is the ID of the work order by which inventory was produced.
from_oper_id	A string that is the ID of the operation by which inventory was produced.
from_seq_no	An integer that is the sequence number by which inventory was produced.
from_ent_id	An integer that is the ID of the storage entity from which the transfer is occurring.
from_ent_name	A string that is the name of the entity from which the transfer is occurring.
from_item_id	A string that is the item that is transferred from the old location.
from_item_desc	A string that is the description of the item that is transferred from the old location.
from_lot_no	A string that is the lot number at the old location. Null indicates it is the same as lot_no.
from_sublot_no	A string that is the sublot number at the old location. Null indicates it is the same as sublot_no.
from_grade_cd	An integer that is the grade of the material that is transferred from the old location. Null indicates it is the same as grade_cd.
from_status_cd	An integer that is the state of the material that is transferred from the old location. Null indicates it is the same as status_cd.
from_qty_txd	A floating point number the quantity that is transferred from the old location. Null indicates it is the same as qty_txd.
from_uom_id	An integer that is the unit of measure for the item at the old location. Null indicates it is the same as uom_id.
from_expiry_date_utc	A datetime that is the expiry date and time for the inventory at the old location in UTC, from the Item_Inv table.
from_expiry_date_local	A datetime that is the expiry date and time for the inventory at the old location in the local time of the old location entity, from the Item_Inv table.
from_expiry_date	A datetime that is the expiry date and time for the inventory at the old location in the local time of the client application that is making the call, converted from the from_expiry_date_utc value.
from_spare1	A string that is the value of the spare1 field in the Item_Inv table prior to the transfer.
from_spare2	A string that is the value of the spare2 field in the Item_Inv table prior to the transfer.
from_spare3	A string that is the value of the spare3 field in the Item_Inv table prior to the transfer.
from_spare4	A string that is the value of the spare4 field in the Item_Inv table prior to the transfer.
from_spare5	A string that is the value of the spare5 field in the Item_Inv table prior to the transfer.
from_spare6	A string that is the value of the spare6 field in the Item_Inv table prior to the transfer.
qty_txd_erp	A floating point number that is the quantity transferred, as sent to an ERP system.
goods_received	A Boolean that is a flag that specifies whether the goods are received from the supplier.
goods_shipped	A Boolean that is a flag that specifies whether the goods are shipped to the customer.
transfer_list_row_id	An integer that is the transfer list record for which this row is a partial or complete fulfillment.
comments	A string that is the explanatory notes for this inventory transfer.
transfer_by	A string that is the ID of the user who made the transfer.
transfer_time_utc	A string that is the transfer time of the item in UTC.
transfer_time_local	A string that is the transfer time of the item in the local time of the storage entity that is the new location.
transfer_time	A datetime that is when the item transfer occurred in the local time of the time zone that was specified in the tz_id parameter in the call header or URL. If the tz_id parameter was not provided or was not valid, then the time is in UTC.
mod_id	The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes.
trans_id	An integer that is the row ID of the inventory transfer record in the Item_Transfer table.

MES Stateless API