API CreateStockDispositions: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „==== Description ==== Method allows You to create new stock dispositions in system. ==== Exact name ==== <code>API_CreateStockDispositions</code> ==== Ty…“ |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádek 16: | Řádek 16: | ||
!Relation | !Relation | ||
|- | |- | ||
|@ | |@StockID | ||
|int | |int | ||
| | | | ||
|ID of | |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 ==== | ==== 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.