API UpdateStockDispositions

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.