API UpdateStockDispositions: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method allows You to update stock dispositions in system. ==== Exact name ==== <code>API_UpdateStockDispositions</code> ==== Type =…“) |
|||
| Řádka 101: | Řádka 101: | ||
|} | |} | ||
| + | ==== Return ==== | ||
| + | 0 : OK | ||
| + | 100 : Item could not be updated | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| + | DECLARE @return_value int | ||
DECLARE @ID int | DECLARE @ID int | ||
DECLARE @StockID int | DECLARE @StockID int | ||
| Řádka 136: | Řádka 140: | ||
WHERE id = 3 | WHERE id = 3 | ||
| − | EXECUTE [API_UpdateStockDispositions] | + | EXECUTE @return_value = [API_UpdateStockDispositions] |
@ID, | @ID, | ||
@StockID, | @StockID, | ||
Aktuální verze z 22. 9. 2017, 09:39
Description
Method allows You to update stock dispositions in system.
Exact name
API_UpdateStockDispositions
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | 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 |
Return
0 : OK 100 : Item could not be updated
Example
DECLARE @return_value int
DECLARE @ID int
DECLARE @StockID int
DECLARE @ProductID int
DECLARE @MinimumQuantity numeric(18,4)
DECLARE @MaximumQuantity numeric(18,4)
DECLARE @IsArchived int
DECLARE @OnStockQuantity decimal(10,3)
DECLARE @FullStockPrice decimal(18,4)
DECLARE @PricePerPiece decimal(18,4)
DECLARE @WarehousePosition nvarchar(50)
DECLARE @ReservedQuantity decimal(18,2)
DECLARE @LastInDate datetime
DECLARE @LastOutDate datetime
DECLARE @LastChangeDate datetime
SELECT @ID = [ID],
@StockID = [StockID],
@ProductID = [ProductID],
@MinimumQuantity = [MinimumQuantity],
@MaximumQuantity = 5,
@IsArchived = [IsArchived],
@OnStockQuantity = [OnStockQuantity],
@FullStockPrice = [FullStockPrice],
@PricePerPiece = [PricePerPiece],
@WarehousePosition = [WarehousePosition],
@ReservedQuantity = [ReservedQuantity],
@LastInDate = [LastInDate],
@LastOutDate = [LastOutDate],
@LastChangeDate = [LastChangeDate]
FROM [API_GetStockDispositions]
WHERE id = 3
EXECUTE @return_value = [API_UpdateStockDispositions]
@ID,
@StockID,
@ProductID,
@MinimumQuantity,
@MaximumQuantity,
@IsArchived,
@OnStockQuantity,
@FullStockPrice,
@PricePerPiece,
@WarehousePosition,
@ReservedQuantity,
@LastInDate,
@LastOutDate,
@LastChangeDate
Notices
None.
