Custom Details Query Samples

Script Example Standards

In this chapter example queries for for the following moments are given.

Module	Moment	Description	Sample Query MSSQL	Sample Query HANA
Goods Receipt	Goods_Receipt_Document	Presents information screen for goods receipt tasks	SAMPLE
Goods Receipt	Goods_Receipt_Line	Presents information screen for goods receipt lines
Stock Counting	Inventory_Counting_Document	Presents information screen for inventory counting tasks	SAMPLE
Extra Functions	Menu_Extra_Item_Search	Presents information screen for item search in extra functions menu
Extra Functions	Menu_Extra_Location_Content	Presents information screen for location content in extra functions menu
Order Picking	Order_Picking_Document	Presents information for order picking tasks
Order Picking	Order_Picking_Line	Presents information for order picking lines which still need to be picked	SAMPLE	SAMPLE
Order Picking	Order_Picking_Line_Comment	Presents information for comments of order picking lines which still need to be picked
Packaging	Packaging_Document	Presents information screen for packaging tasks
Packaging	Packaging_Line	Presents information screen for packaging lines
Packaging	Packaging_Package_Content	Presents information screen for packaging content
Production	Production_Picking_Document	Presents information screen for production picking tasks
Production	Prodcution_Picking_Line	Presents information for production picking lines which still need to be picked
Production	Prodcution_Picking_Line_Comment	Presents information for comments of production picking lines which still need to be picked
Production	Production_Receipt_Document	Presents information screen for production receipt tasks
Production	Production_Receipt_Line	Presents information screen for production receipt lines
PutAway	PutAway_Document	Presents information screen for putaway tasks	SAMPLE
PutAway	PutAway_Line	Presents information screen for putaway lines
Replenishment	Replenishment_Document	Presents information screen for replenishment tasks
Replenishment	Replenishment_Items_Get	Presents information for replenishment lines which still need to be picked
Replenishment	Replenishment_Items_Put	Presents information for replenishment lines which still need to be put away
Return Receipt	Sales_Return_Document	Presents information screen for sales return tasks
Return Receipt	Sales_Return_Line	Presents information screen for sales return lines
Shipment	Shipment_Document	Presents information for combined shipping and packing tasks	SAMPLE	SAMPLE
Shipment	Shipment_Line	Presents information for combined shipping and packing lines
Shipment	Shipment_Package_Content	Presents information screen for combined shipping and packaging content
Shipment	Shipment_Blind_Package	Presents information screen for combined blind shipping and packaging
Shipping	Shipping_Order_Document	Presents information for shipping order tasks
Shipping	Shipping_Order_Document_Package	Presents information for shipping order packaging tasks
Shipping	Shipping_Order_Overview	Presents information for shipping order overview
Stock Transfer	Stock_Transfer_Document	Presents information for stock transfer tasks	SAMPLE	SAMPLE
Stock Transfer	Stock_Transfer_Line_Get	Presents information for stock transfer lines which still need to be picked Note Will not work for new tasks created from WarehousePro Client directly	SAMPLE	SAMPLE
Stock Transfer	Stock_Transfer_Line_Put	Presents information for stock transfer lines which still need to be put away Note Will not work for new tasks created from WarehousePro Client directly	SAMPLE	SAMPLE

Script Example Standards

Note

Note