API WMS WarehouseInternalMovements: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method provides warehouse internal movements through the mobile warehouse terminal including general information like user name, quan…“) |
(Žádný rozdíl)
|
Verze z 12. 9. 2017, 12:30
Description
Method provides warehouse internal movements through the mobile warehouse terminal including general information like user name, quantity, weight, date and time etc.
Exact name
API_WMS_WarehouseInternalMovements
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| MovementID | int | Internal system ID of item movement | |
| MovementType | int | 0 = N/A
1 = AutoRelease 2 = TerminalRelease 3 = CheckDelivery 4 = LocationIn 5 = LocationOut 6 = LocationInventory 7 = LocationTransfer 8 = LocationSearchProduct 9 = ManualEdit 10 = RetailSale |
|
| WarehouseID | int | Internal system ID of warehouse | |
| PositionID | int | Internal system ID of position | |
| InsertedDate | datetime | Date of item insertion | |
| ItemQty | decimal | Movement item quantity | |
| InsertedUserID | int | Internal system ID of user updated | |
| InsertedUserName | nvarchar(193) | Name of inserted user | |
| 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_WarehouseInternalMovements]
Notices
None
