API WMS GetWarehousePositions
Z Podpora.nextis.cz
Description
Method provides list of warehouse positions.
Exact name
API_WMS_GetWarehousePositions
Type
Standard view.
Specification
Column | Data type | Description | Relation |
---|---|---|---|
ID | int | Internal system ID of position | |
WarehouseID | int | Internal system ID of warehouse | |
Sector | nvarchar | 1st part of position | |
Floor | nvarchar | 2nd part of position | |
Aisle | nvarchar | 3rd part of position | |
Row | nvarchar | 4th part of position | |
Rack | nvarchar | 5th part of position | |
Shelf | nvarchar | 6th part of position | |
Section | nvarchar | 7th part of position | |
ShelfSection | nvarchar | 8th. part of position | |
Position | nvarchar | Full position based on pattern | |
PositionTypeStatus | int | 0 = Regular position, 1 = Picking position |
Example
SELECT * FROM [API_WMS_GetWarehousePositions]
Notices
None