PickQuery [PICK015]
DATASCOPE.SDK.BusinessObjects.Picking.OrderPicking.PickQuery()
A Business Object to return a list of items that still need to be picked on a Picking Slip.
It is designed to be used with several other Picking objects within DATASCOPE WMS. These objects can re-create the entire Order Picking process within the core system. This object forms one of the first steps in the process, namely listing the stock required to be picked for a particular Picking Slip.
The Business Object matches the Items tab within the core Picking module and will allow third-party developers to pull information about items to be picked. This can be used in multiple ways, either to show users the items OR in a more automated process to run through the lines and process them using the other Order Picking Business Objects.
This object falls under the Order Picking functional area and this is specific to Sales Order Picking and not Job or Work in Progress.
For a detailed overview on working with DATASCOPE PREMIUM WMS Business Objects, refer to E.Net Business Objects
If you don’t like reading, you can watch the video.
None
No Specifications
RELEASE NOTES
Release notes 24R2 (Ticket # 8382) - PickQuery Business Object development.
Description
This is a query Business Object and works slightly different than the standard Post Business Objects, as it will return the data within the Results Business Object of the call. It will allow a 3rd party application or script to pull the list of information from the system, by simply providing the pick slip number. The same information provided in the Items tab will be provided to the 3rd party caller.
Code | PIK015 |
---|---|
Name | PickQuery |
Module | Picking |
Functional Area | OrderPicking |
Name Space/Class | DATASCOPE.SDK.BusinessObjects.Picking.OrderPicking.PickQuery() |
Release Date | August 2024 |
Release Version | v24.2 |
Prerequisites | None |
---|---|
SYSPRO Objects | Â |
Parameters
s BO performs a functional perspective matching of the core HTML5 picking screens.
Returns:
Response - Success
Response Result set to True
Response Message "Query Successful"
Response Object "A list Pick Slip Line Items"
Response - Failure
Response Result set to False
Response Message - Error generated
Name | Description | Mandatory field | Data Type | Default Value |
---|---|---|---|---|
pReferenceType | Can only be set to PICK_SLIP/MASTER_SHIPMENT_NUMBER/CARTON_NUMBER indicating the Type of data to load corresponding to Sales Pick to Pick Slip, Sales Pick to Track ID, Sales Order MSN Picking or Sales Order Carton Picking. If not supplied or outside of the eNum types will cause a Error | YES | eNum | 0 |
pReferenceNumber | Should be populated with the applicable Pick Slip Number, Master Shipment Number or Carton Number, based on the respective PICK_SLIP/MASTER_SHIPMENT_NUMBER/CARTON_NUMBER supplied in the pReferenceType field. Must be a valid Reference, if not, an Error will be generated. | YES | string | <blank> |
Validation
The following validation must happen.
Reference Number - the Reference number must match the options in Reference Type, which is PICK_SLIP, MASTER_SHIPMENT_NUMBER, and CARTON_NUMBER
Technical Specification
<sample code>
Testing the BO
The Business Object Harness application should be used to assist in troubleshooting and testing any of the DATASCOPE WMS Business Objects.
Ensure you followed the installation process to install and configure the Business Object Harness application.
To test the Business Object
o  Open the Business Object Harness
o  Enter the Company ID you would like to login to, followed by a valid Operator, along with its password and company password (if any). Clicking the Login button will then attempt to log in to the system using the WebAPI.
o  The first step in posting an object is to select and add it to the main content window.
o  Now you are ready to start testing the Business Object.