API CreateStockDispositions: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 2 mezilehlé verze od stejného uživatele.) | |||
| Řádek 16: | Řádek 16: | ||
!Relation | !Relation | ||
|- | |- | ||
|StockID | |@StockID | ||
|int | |int | ||
| | | | ||
| Řádek 22: | Řádek 22: | ||
|API_GetStocks.ID | |API_GetStocks.ID | ||
|- | |- | ||
|ProductID | |@ProductID | ||
|int | |int | ||
| | | | ||
| Řádek 28: | Řádek 28: | ||
|API_GetProducts.ID | |API_GetProducts.ID | ||
|- | |- | ||
|MinimumQuantity | |@MinimumQuantity | ||
|numeric(18,4) | |numeric(18,4) | ||
| | | | ||
| Řádek 34: | Řádek 34: | ||
| | | | ||
|- | |- | ||
|MaximumQuantity | |@MaximumQuantity | ||
|numeric(18,4) | |numeric(18,4) | ||
| | | | ||
| Řádek 40: | Řádek 40: | ||
| | | | ||
|- | |- | ||
|IsArchived | |@IsArchived | ||
|int | |int | ||
| | | | ||
| Řádek 46: | Řádek 46: | ||
| | | | ||
|- | |- | ||
|OnStockQuantity | |@OnStockQuantity | ||
|decimal(10,3) | |decimal(10,3) | ||
| | | | ||
| Řádek 52: | Řádek 52: | ||
| | | | ||
|- | |- | ||
|FullStockPrice | |@FullStockPrice | ||
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádek 58: | Řádek 58: | ||
| | | | ||
|- | |- | ||
|PricePerPiece | |@PricePerPiece | ||
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádek 64: | Řádek 64: | ||
| | | | ||
|- | |- | ||
|WarehousePosition | |@WarehousePosition | ||
|nvarchar(50) | |nvarchar(50) | ||
| | | | ||
| Řádek 70: | Řádek 70: | ||
| | | | ||
|- | |- | ||
|ReservedQuantity | |@ReservedQuantity | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádek 76: | Řádek 76: | ||
| | | | ||
|- | |- | ||
|LastInDate | |@LastInDate | ||
|datetime | |datetime | ||
| | | | ||
| Řádek 82: | Řádek 82: | ||
| | | | ||
|- | |- | ||
|LastOutDate | |@LastOutDate | ||
|datetime | |datetime | ||
| | | | ||
| Řádek 88: | Řádek 88: | ||
| | | | ||
|- | |- | ||
|LastChangeDate | |@LastChangeDate | ||
|datetime | |datetime | ||
| | | | ||
|Last change date | |Last change date | ||
||} | | | ||
|} | |||
==== Return ==== | |||
0 : OK | |||
100 : Item could not be created | |||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
EXEC [API_CreateStockDispositions] @ | DECLARE @return_value int | ||
EXEC @return_value = [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. | ||
Aktuální verze z 22. 9. 2017, 08:38
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 |
Return
0 : OK 100 : Item could not be created
Example
DECLARE @return_value int
EXEC @return_value = [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.