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