API WMS TerminalOrderPickingOverview - Historie editací

Worek: /* Specification */

2017-09-07T14:37:34Z

‎Specification

Worek: /* Specification */

2017-09-07T14:36:43Z

‎Specification

Worek: /* Specification */

2017-09-07T13:44:35Z

‎Specification

Worek: 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…“

2017-09-07T13:40:09Z

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…“

Nová stránka

==== 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 ====
<code>API_WMS_TerminalOrderPickingOverview</code>

==== Type ====
Standard view.

==== Specification ====
{| class="wikitable"
!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

@@ Řádka 17: / Řádka 17: @@
 |ReleaseItemID
 |int
-|Internal system ID
+|Internal system ID of released order item
+|
 |-
 |ReleasePreparedID
 |int
-|Internal system ID
+|Internal system ID of prepared released order item
+|
 |-

@@ Řádka 15: / Řádka 15: @@
 !Relation
 |-
-|ID
+|ReleaseItemID
 |int
 |Internal system ID
+|
 |-
@@ Řádka 53: / Řádka 63: @@
 |int
 |1 = Weight specified, 0 = weight not specified
+|
 |}

@@ Řádka 55: / Řádka 55: @@
+|
 |-
-|PickingType
+|OrderPickingType
 |int
 |0 = Picking From Positions, 1 = Sorting To Transports