API GetStockDispositions: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method gives You overview of existing stock dispositions in system. ==== Exact name ==== <code>API_GetStockDispositions</code> ====…“) |
(Žádný rozdíl)
|
Aktuální verze z 31. 7. 2017, 10:25
Description
Method gives You overview of existing stock dispositions in system.
Exact name
API_GetStockDispositions
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| StockID | int | ID of stock from stock list (see relation) | API_GetStocks.ID |
| ProductID | int | ID of product from products list (see relation) | API_GetProducts.ID |
| MinimumQuantity | numeric(18,4) | Minimum quantity | |
| MaximumQuantity | numeric(18,4) | Maximum quantity | |
| IsArchived | int | Is archived | |
| OnStockQuantity | decimal(10,3) | On stock quantity | |
| FullStockPrice | decimal(18,4) | Full stock price | |
| PricePerPiece | decimal(18,4) | Price per piece | |
| WarehousePosition | nvarchar(50) | Warehouse position | |
| ReservedQuantity | decimal(18,2) | Reserved quantity | |
| LastInDate | datetime | LastIn date | |
| LastOutDate | datetime | Last out date | |
| LastChangeDate | datetime | Last change date |
Example
SELECT TOP 1000 * FROM [API_GetStockDispositions]
Notices
None.
