GetAll Method (ReceiptLot)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal poId As String, _
ByVal dateReceivedUtc As Nullable(Of Date), _
ByVal itemId As String, _
ByVal lotNo As String, _
ByVal sublotNo As String, _
ByVal uomId As Nullable(Of Integer), _
ByVal transId As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal rowId As Nullable(Of Integer) _
) As DataSet
'Usage
Dim poId As String
Dim dateReceivedUtc As Nullable(Of Date)
Dim itemId As String
Dim lotNo As String
Dim sublotNo As String
Dim uomId As Nullable(Of Integer)
Dim transId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim value As DataSet
value = ReceiptLot.GetAll(poId, dateReceivedUtc, itemId, lotNo, sublotNo, uomId, transId, lastEditBy, lastEditAt, rowId)
public static DataSet GetAll(
string poId,
Nullable<DateTime> dateReceivedUtc,
string itemId,
string lotNo,
string sublotNo,
Nullable<int> uomId,
Nullable<int> transId,
string lastEditBy,
Nullable<DateTime> lastEditAt,
Nullable<int> rowId
)
Parameters
- poId
- Optional filter parameter. Holds the purchase order ID.
- dateReceivedUtc
- Optional filter parameter. Holds the date and time when the goods were received, in UTC.
- itemId
- Optional filter parameter. Holds the ID of the item for the goods received.
- lotNo
- Optional filter parameter. Holds the lot number of the goods received.
- sublotNo
- Optional filter parameter. Holds the sublot number of the goods received.
- uomId
- Optional filter parameter. Holds the identifier of the unit of measure for the goods received.
- transId
- Optional filter parameter. Holds the transfer identifier for the goods received.
- lastEditBy
- Optional filter parameter. Holds the user who created or last updated the record.
- lastEditAt
- Optional filter parameter. Holds the date and time that the record was added or last updated.
- rowId
- Optional filter parameter. Holds the unique row identifier of the receipt lot record in the Receipt_Lot table.
Return Value
Returns a DataSet that contains records that satisfy the specified filters. The returned records include columns from the Receipt_Lot table. If no matching records found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Names |
Description |
|---|---|
|
po_id |
A string that is the ID of the purchase order with which the goods received are associated. |
|
date_rcvd_utc |
A datetime that indicates when the goods were received, in UTC. |
|
date_rcvd_local |
A datetime that indicates when the goods were received, in the local time of the entity at which the goods were received. |
|
date_rcvd |
A datetime that indicates when the goods were received, in the local time of of the client from which the method was called. |
|
item_id |
A string that is the ID of the item received. |
|
lot_no |
A string that is the lot number of the goods received. |
|
sublot_no |
A string that is the sublot number of the goods received. |
|
quantity |
A double that is the quantity of goods received. |
|
uom_id |
An integer that is the identifier of the unit of measure for the goods received. |
|
trans_id |
An integer that is the transfer identifier for the goods received. |
|
last_edit_comment |
A string that contains comments about why the record was added or updated. |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. |
|
last_edit_at |
A datetime that indicates when the record was added or last updated. |
|
row_id |
An integer that is the record's unique row ID. |