GetAll Method (Shipment)
- Last UpdatedNov 06, 2025
- 4 minute read
'Declaration
Public Shared Function GetAll( _
ByVal custId As String, _
ByVal poId As String, _
ByVal soLineNumber As Nullable(Of Integer), _
ByVal shipDateUtc As Nullable(Of Date), _
ByVal shipVia As String, _
ByVal shipBy As String, _
ByVal shipFrom 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 custId As String
Dim poId As String
Dim soLineNumber As Nullable(Of Integer)
Dim shipDateUtc As Nullable(Of Date)
Dim shipVia As String
Dim shipBy As String
Dim shipFrom 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 = Shipment.GetAll(custId, poId, soLineNumber, shipDateUtc, shipVia, shipBy, shipFrom, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
string custId,
string poId,
Nullable<int> soLineNumber,
Nullable<DateTime> shipDateUtc,
string shipVia,
string shipBy,
Nullable<int> shipFrom,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- custId
- Optional filter parameter. Holds the customer ID.
- poId
- Optional filter parameter. Holds the purchase order ID.
- soLineNumber
- Optional filter parameter. Holds the sales order line number of the goods shipped.
- shipDateUtc
- Optional filter parameter. Holds the date and time when the goods were shipped, in UTC.
- shipVia
- Optional filter parameter. Holds the description of how the goods were shipped.
- shipBy
- Optional filter parameter. Holds the name of who shipped the goods.
- shipFrom
- Optional filter parameter. Holds the ID of the entity from which the goods were shipped.
- 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 Shipment 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 |
|---|---|
|
cust_id |
A string that is the customer ID. |
|
po_id |
A string that is the ID of the purchase order with which the goods shipped are associated. |
|
so_line_no |
An integer that is the sales order line number of the goods shipped. |
|
ship_date_utc |
A datetime that indicates when the goods were shipped, in UTC. |
|
ship_date_local |
A datetime that indicates when the goods were shipped, in the local time of the entity from which the goods were shipped. |
|
ship_date |
A datetime that indicates when the goods were shipped, in the local time of of the client from which the method was called. |
|
ship_via |
A string that describes how the goods were shipped. |
|
ship_by |
A string that identifies who shipped the goods. |
|
ship_from |
An integer that is the ID of the entity from which the goods were shipped. |
|
ship_from_ent_name |
A string that is the name of the entity from which the goods were shipped. |
|
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. |
|
cust_name |
A string that is the customer name. |
|
item_id |
A string that is the ID of the item shipped. |
|
item_desc |
A string that is the description of the item shipped. |
|
num_decimals |
An integer that contains the number of decimal places used for quantity values of the item shipped. |
|
mod_id |
The current modification ID of the record. This ID is a binary number that increments each time the record is modified. It is used by methods that modify or delete the record for optimistic concurrency control. |
|
total_to_ship |
A double that is the total quantity of goods to be shipped. |
|
total_qty_shipped |
A double that is the total quantity of goods shipped. |
|
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. |