API CreateStockDispositions: Porovnání verzí
Z Podpora.nextis.cz
(→Specification) |
|||
| Řá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 | ||
| − | ||} | + | | |
| + | |} | ||
==== Example ==== | ==== Example ==== | ||
Verze z 31. 7. 2017, 16: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.
