API CreateStockDispositions - Historie editací

Chrzaszcz v 22. 9. 2017, 08:38

2017-09-22T08:38:57Z

← Starší verze		Verze z 22. 9. 2017, 08:38
Řádek 94:		Řádek 94:
	\|		\|
	\|}		\|}

			==== Return ====
			0 : OK
			100 : Item could not be created

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	EXEC [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		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.

Chrzaszcz: /* Example */

2017-07-31T14:15:27Z

Example

← Starší verze		Verze z 31. 7. 2017, 14:15
Řádek 97:		Řádek 97:
	==== 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'~~		EXEC [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.

Chrzaszcz: /* Specification */

2017-07-31T14:09:05Z

Specification

← Starší verze		Verze z 31. 7. 2017, 14:09
Řá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 ====

Chrzaszcz v 31. 7. 2017, 14:08

2017-07-31T14:08:04Z

@@ Řádek 16: / Řádek 16: @@
 !Relation
 |-
-|@WorkshopID
+|StockID
 |int
+|
-|ID of workshop from workshop list (see relation)
+|ID of stock from stock list (see relation)
-|API_GetWorkshops.ID
+|API_GetStocks.ID
-|}
+|-
 ==== Example ====

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new stock dispositions in system. ==== Exact name ==== `API_CreateStockDispositions` ==== Ty…“

2017-07-31T14:05:10Z

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…“

Nová stránka

==== Description ====
Method allows You to create new stock dispositions in system.

==== Exact name ====
<code>API_CreateStockDispositions</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@WorkshopID
|int
|
|ID of workshop from workshop list (see relation)
|API_GetWorkshops.ID
|}

==== Example ====
<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'
</syntaxhighlight>

==== Notices ====
None.

API CreateStockDispositions - Historie editací

Chrzaszcz v 22. 9. 2017, 08:38

Chrzaszcz: /* Example */

Chrzaszcz: /* Specification */

Chrzaszcz v 31. 7. 2017, 14:08

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new stock dispositions in system. ==== Exact name ==== API_CreateStockDispositions ==== Ty…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new stock dispositions in system. ==== Exact name ==== `API_CreateStockDispositions` ==== Ty…“