API WMS TerminalOrderPickingOverview

Z Podpora.nextis.cz
Verze z 7. 9. 2017, 15:37, kterou vytvořil Worek (diskuse | příspěvky) (Specification)
(rozdíl) ← Starší verze | zobrazit aktuální verzi (rozdíl) | Novější verze → (rozdíl)
Přejít na: navigace, hledání

Description

Method provides overview of order items picked through the mobile warehouse terminal including general information like user name, quantity, date and time etc.

Exact name

API_WMS_TerminalOrderPickingOverview

Type

Standard view.

Specification

Column Data type Description Relation
ReleaseItemID int Internal system ID of released order item
ReleasePreparedID int Internal system ID of prepared released order item
OrderPickingType int 0 = Picking From Positions, 1 = Sorting To Transports
InsertedDate datetime Date of item insertion
ItemQty decimal Expedited quantity
InsertedUserID int Internal system ID of user
InsertedUserName nvarchar(150) User name
ItemWeightUnit decimal Item weight per unit
ItemWeightTotal decimal Item weight total
ItemWeightSpecified int 1 = Weight specified, 0 = weight not specified

Example

SELECT * FROM [API_WMS_TerminalOrderPickingOverview]

Notices

None