API WMS TerminalExpeditionOverview: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „popis“ |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 2 mezilehlé verze od jednoho dalšího uživatele.) | |||
| Řádek 1: | Řádek 1: | ||
==== 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, 13: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