API CreateStockDispositions: Porovnání verzí
Z Podpora.nextis.cz
(→Specification) |
(→Example) |
||
| Řádka 97: | Řádka 97: | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| − | EXEC [API_CreateStockDispositions] @ | + | EXEC [API_CreateStockDispositions] @StockID= 1 ,@ProductID= 1 ,@MinimumQuantity= 5 ,@MaximumQuantity= 10 ,@IsArchived int = 0 ,@OnStockQuantity= 10 ,@FullStockPrice= 100 ,@PricePerPiece= 10 ,@WarehousePosition= 'A16-12-1' ,@ReservedQuantity= 2 ,@LastInDate datetime = null ,@LastOutDate datetime = null ,@LastChangeDate datetime = null |
</syntaxhighlight> | </syntaxhighlight> | ||
==== Notices ==== | ==== Notices ==== | ||
None. | None. | ||
Verze z 31. 7. 2017, 16:15
Description
Method allows You to create new stock dispositions in system.
Exact name
API_CreateStockDispositions
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @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
EXEC [API_CreateStockDispositions] @StockID= 1 ,@ProductID= 1 ,@MinimumQuantity= 5 ,@MaximumQuantity= 10 ,@IsArchived int = 0 ,@OnStockQuantity= 10 ,@FullStockPrice= 100 ,@PricePerPiece= 10 ,@WarehousePosition= 'A16-12-1' ,@ReservedQuantity= 2 ,@LastInDate datetime = null ,@LastOutDate datetime = null ,@LastChangeDate datetime = null
Notices
None.
