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 =…“) |
(Žádný rozdíl)
|
Verze z 2. 8. 2017, 08:57
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 |
Example
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 [API_UpdateStockDispositions]
@ID,
@StockID,
@ProductID,
@MinimumQuantity,
@MaximumQuantity,
@IsArchived,
@OnStockQuantity,
@FullStockPrice,
@PricePerPiece,
@WarehousePosition,
@ReservedQuantity,
@LastInDate,
@LastOutDate,
@LastChangeDate
Notices
None.
