API WMS TerminalExpeditionOverview: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „popis“)
 
 
(Nejsou zobrazeny 2 mezilehlé verze od jednoho dalšího uživatele.)
Řádka 1: Řádka 1:
−
popis
+
==== Description ====
 +
Method provides overview of items, expedited through the mobile warehouse terminal including general information like user name, quantity, date and time etc.
 +
 
 +
==== Exact name ====
 +
<code>API_WMS_TerminalExpeditionOverview</code>
 +
 
 +
==== Type ====
 +
Standard view.
 +
 
 +
==== Specification ====
 +
{| class="wikitable"
 +
!Column
 +
!Data type
 +
!Description
 +
!Relation
 +
|-
 +
|UniqueKey
 +
|int
 +
|Internal system id
 +
|
 +
|-
 +
|InsertedDate
 +
|datetime
 +
|Date of item insertion
 +
|
 +
|-
 +
|ItemQty
 +
|decimal
 +
|Expedited quantity
 +
|
 +
|-
 +
|InsertedIDUser
 +
|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_TerminalExpeditionOverview]
 +
 
 +
==== Notices ====
 +
None

Aktuální verze z 6. 9. 2017, 14:59

Description

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

Exact name

API_WMS_TerminalExpeditionOverview

Type

Standard view.

Specification

Column Data type Description Relation
UniqueKey int Internal system id
InsertedDate datetime Date of item insertion
ItemQty decimal Expedited quantity
InsertedIDUser 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_TerminalExpeditionOverview]

Notices

None

Citováno z „https://podpora.nextis.cz/index.php?title=API_WMS_TerminalExpeditionOverview&oldid=622“