API WMS WarehouseInternalMovements

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	API_WMS_GetWarehousePositions.ID
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