API WMS TerminalOrderPickingOverview

Z Podpora.nextis.cz
Verze z 7. 9. 2017, 15:40, kterou vytvořil Worek (diskuse | příspěvky) (Založena nová stránka s textem „==== Description ==== Method provides overview of order items picked through the mobile warehouse terminal including general information like user name, qu…“)
(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
ID int Internal system ID
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
PickingType int 0 = Picking From Positions, 1 = Sorting To Transports

Example

SELECT * FROM [API_WMS_TerminalOrderPickingOverview]

Notices

None