API CreateStockDispositions: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledá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…“)
 
 
(Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.)
Řádka 16: Řádka 16:
 
!Relation
 
!Relation
 
|-
 
|-
−
|@WorkshopID
+
|@StockID
 
|int
 
|int
 
|
 
|
−
|ID of workshop from workshop list (see relation)
+
|ID of stock from stock list (see relation)
−
|API_GetWorkshops.ID
+
|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] @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'
+
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.

Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateStockDispositions&oldid=1041“