GetAll Method (Receipt)
- 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 poLineNumber As Nullable(Of Integer), _
ByVal vendorId As String, _
ByVal invoice As String, _
ByVal receivedBy As String, _
ByVal receivedAt As Nullable(Of Integer), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim poId As String
Dim dateReceivedUtc As Nullable(Of Date)
Dim itemId As String
Dim poLineNumber As Nullable(Of Integer)
Dim vendorId As String
Dim invoice As String
Dim receivedBy As String
Dim receivedAt As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Receipt.GetAll(poId, dateReceivedUtc, itemId, poLineNumber, vendorId, invoice, receivedBy, receivedAt, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
string poId,
Nullable<DateTime> dateReceivedUtc,
string itemId,
Nullable<int> poLineNumber,
string vendorId,
string invoice,
string receivedBy,
Nullable<int> receivedAt,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- poId
- Optional filter parameter. Holds the ID of a purchase order.
- 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.
- poLineNumber
- Optional filter parameter. Holds the PO line number of the goods received.
- vendorId
- Optional filter parameter. Holds the vendor ID.
- invoice
- Optional filter parameter. Holds the invoice or bill of lading number for the goods received.
- receivedBy
- Optional filter parameter. Holds the name of who received the goods.
- receivedAt
- Optional filter parameter. Holds the ID of the entity at which the goods were received.
- spare1
- Optional filter parameter. Holds the contents of the user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of the user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of the user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of the user-defined spare4 field.
- 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.
Return Value
Returns a DataSet that contains all the records in the Receipts table that satisfy the specified filters. 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. |
|
po_line_no |
An integer that is the purchase order line number of the goods received. |
|
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. |
|
vend_id |
A string that is the vendor ID. |
|
invoice |
A string that is the invoice or bill of lading number for the goods received. |
|
rcvd_by |
A string that indicates who received the goods. |
|
rcvd_at |
An integer that is the ID of the entity at which the goods were received. |
|
receipt_ent_name |
A string that is the name of the entity at which the goods were received. |
|
spare1 |
A string that is the content of the user-defined spare1 field. |
|
spare2 |
A string that is the content of the user-defined spare2 field. |
|
spare3 |
A string that is the content of the user-defined spare3 field. |
|
spare4 |
A string that is the content of the user-defined spare4 field. |
|
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. |