API CreateStockDispositions: Porovnání verzí
Z Podpora.nextis.cz
| (Nejsou zobrazeny 2 mezilehlé verze od stejného uživatele.) | |||
| Řádka 16: | Řádka 16: | ||
!Relation | !Relation | ||
|- | |- | ||
| − | |StockID | + | |@StockID |
|int | |int | ||
| | | | ||
| Řádka 22: | Řádka 22: | ||
|API_GetStocks.ID | |API_GetStocks.ID | ||
|- | |- | ||
| − | |ProductID | + | |@ProductID |
|int | |int | ||
| | | | ||
| Řádka 28: | Řádka 28: | ||
|API_GetProducts.ID | |API_GetProducts.ID | ||
|- | |- | ||
| − | |MinimumQuantity | + | |@MinimumQuantity |
|numeric(18,4) | |numeric(18,4) | ||
| | | | ||
| Řádka 34: | Řádka 34: | ||
| | | | ||
|- | |- | ||
| − | |MaximumQuantity | + | |@MaximumQuantity |
|numeric(18,4) | |numeric(18,4) | ||
| | | | ||
| Řádka 40: | Řádka 40: | ||
| | | | ||
|- | |- | ||
| − | |IsArchived | + | |@IsArchived |
|int | |int | ||
| | | | ||
| Řádka 46: | Řádka 46: | ||
| | | | ||
|- | |- | ||
| − | |OnStockQuantity | + | |@OnStockQuantity |
|decimal(10,3) | |decimal(10,3) | ||
| | | | ||
| Řádka 52: | Řádka 52: | ||
| | | | ||
|- | |- | ||
| − | |FullStockPrice | + | |@FullStockPrice |
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádka 58: | Řádka 58: | ||
| | | | ||
|- | |- | ||
| − | |PricePerPiece | + | |@PricePerPiece |
|decimal(18,4) | |decimal(18,4) | ||
| | | | ||
| Řádka 64: | Řádka 64: | ||
| | | | ||
|- | |- | ||
| − | |WarehousePosition | + | |@WarehousePosition |
|nvarchar(50) | |nvarchar(50) | ||
| | | | ||
| Řádka 70: | Řádka 70: | ||
| | | | ||
|- | |- | ||
| − | |ReservedQuantity | + | |@ReservedQuantity |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádka 76: | Řádka 76: | ||
| | | | ||
|- | |- | ||
| − | |LastInDate | + | |@LastInDate |
|datetime | |datetime | ||
| | | | ||
| Řádka 82: | Řádka 82: | ||
| | | | ||
|- | |- | ||
| − | |LastOutDate | + | |@LastOutDate |
|datetime | |datetime | ||
| | | | ||
| Řádka 88: | Řádka 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, 09: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.
