API CreateStockDispositions: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
|||
| Řá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 | ||
||} | | | ||
|} | |||
==== Example ==== | ==== Example ==== | ||
Verze z 31. 7. 2017, 14:09
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 |
Example
EXEC [API_CreateStockDispositions] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
Notices
None.