API CreateProduct - Historie editací

Chrzaszcz v 13. 8. 2020, 08:24

2020-08-13T08:24:04Z

← Starší verze		Verze z 13. 8. 2020, 08:24
Řádek 68:		Řádek 68:
	\|		\|
	\|Basic price		\|Basic price
			\|
			\|-
			\|@InfoReturnOfGoods
			\|nvarchar(50)
			\|
			\|Info return of goods
	\|		\|
	\|}		\|}
Řádek 78:		Řádek 84:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	DECLARE @return_value int		DECLARE @return_value int
	EXEC @return_value = [API_CreateProduct] @SupplierID= 2 ,@GroupID= 14 ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@Prefix= '' ,@SupplierItemName= 'SupplierItemName' ,@MinimumOrderableQuantity= 1 ,@ForeignPrice= 110 ,@BasicPrice= 190		EXEC @return_value = [API_CreateProduct] @SupplierID= 2 ,@GroupID= 14 ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@Prefix= '' ,@SupplierItemName= 'SupplierItemName' ,@MinimumOrderableQuantity= 1 ,@ForeignPrice= 110 ,@BasicPrice= 190, @InfoReturnOfGoods=''
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 22. 9. 2017, 08:36

2017-09-22T08:36:12Z

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

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

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	EXEC [API_CreateProduct] @SupplierID= 2 ,@GroupID= 14 ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@Prefix= '' ,@SupplierItemName= 'SupplierItemName' ,@MinimumOrderableQuantity= 1 ,@ForeignPrice= 110 ,@BasicPrice= 190		DECLARE @return_value int
			EXEC @return_value = [API_CreateProduct] @SupplierID= 2 ,@GroupID= 14 ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@Prefix= '' ,@SupplierItemName= 'SupplierItemName' ,@MinimumOrderableQuantity= 1 ,@ForeignPrice= 110 ,@BasicPrice= 190
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 7. 8. 2017, 07:23

2017-08-07T07:23:51Z

← Starší verze		Verze z 7. 8. 2017, 07:23
Řádek 15:		Řádek 15:
	!Description		!Description
	!Relation		!Relation
	\|-
	~~\|@GroupID~~
	~~\|int~~
	\|
	\|
	~~\|API_GetProductGroups.ID~~
	\|-		\|-
	\|@SupplierID		\|@SupplierID
	\|int		\|int
	\|		\|
	\|~~SupplierID~~		\|Supplier ID
	\|API_GetCustomers.ID		\|API_GetCustomers.ID
	\|-		\|-
	\|@~~ProductCode~~		\|@GroupID
	~~\|nvarchar(40)~~
	\|
	~~\|Product code~~
	\|
	\|-
	~~\|@TypeID~~
	\|int		\|int
	\|		\|
	\|~~TypeID.~~		\|Group ID
	~~1 - products~~		\|API_GetProductGroups.ID
	\|
	\|-		\|-
	\|@~~MinimumOrderableQuantity~~		\|@SupplierProductCode
	\|~~decimal~~(~~18,2~~)		\|nvarchar(40)
	\|		\|
	\|~~Minimum orderable quantity~~		\|Supplier product code
	\|		\|
	\|-		\|-
	\|@~~BasicPrice~~		\|@ManufacturerSupplier
	\|~~decimal~~(~~18,6~~)		\|nvarchar(50)
	\|		\|
	\|~~Basic price~~		\|Manufacturer supplier
	\|		\|
	\|-		\|-
	\|@~~CreatedDate~~		\|@Prefix
	\|~~datetime~~		\|nvarchar(3)
	\|		\|
	\|~~Created date~~		\|Prefix
	\|
	\|-
	~~\|@UpdatedDate~~
	~~\|datetime~~
	\|
	~~\|Updated date~~
	\|		\|
	\|-		\|-
Řádek 71:		Řádek 52:
	\|		\|
	\|-		\|-
	\|@~~SupplierProductCode~~		\|@MinimumOrderableQuantity
	\|~~nvarchar~~(40)		\|decimal(18,2)
	\|		\|
	\|~~Supplier product code~~		\|Minimum orderable quantity
	\|
	\|-
	~~\|@Prefix~~
	~~\|nvarchar(3)~~
	\|
	~~\|Prefix~~
	\|
	\|-
	~~\|@ManufacturerSupplier~~
	~~\|nvarchar(50)~~
	\|
	~~\|Manufacturer supplier~~
	\|		\|
	\|-		\|-
Řádek 95:		Řádek 64:
	\|		\|
	\|-		\|-
	\|@~~RetailPrice~~		\|@BasicPrice
	\|decimal(18,6)		\|decimal(18,6)
	\|		\|
	\|~~Retail~~ price		\|Basic price
	\|		\|
	\|}		\|}

Chrzaszcz v 7. 8. 2017, 07:17

2017-08-07T07:17:43Z

← Starší verze		Verze z 7. 8. 2017, 07:17
Řádek 16:		Řádek 16:
	!Relation		!Relation
	\|-		\|-
	\|ID		\|@GroupID
	~~\|int~~
	\|
	~~\|Internal system id~~
	\|
	\|-
	\|GroupID
	\|int		\|int
	\|		\|
Řádek 28:		Řádek 22:
	\|API_GetProductGroups.ID		\|API_GetProductGroups.ID
	\|-		\|-
	\|SupplierID		\|@SupplierID
	\|int		\|int
	\|		\|
Řádek 34:		Řádek 28:
	\|API_GetCustomers.ID		\|API_GetCustomers.ID
	\|-		\|-
	\|ProductCode		\|@ProductCode
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
Řádek 40:		Řádek 34:
	\|		\|
	\|-		\|-
	\|TypeID		\|@TypeID
	\|int		\|int
	\|		\|
Řádek 47:		Řádek 41:
	\|		\|
	\|-		\|-
	\|MinimumOrderableQuantity		\|@MinimumOrderableQuantity
	\|decimal(18,2)		\|decimal(18,2)
	\|		\|
Řádek 53:		Řádek 47:
	\|		\|
	\|-		\|-
	\|BasicPrice		\|@BasicPrice
	\|decimal(18,6)		\|decimal(18,6)
	\|		\|
Řádek 59:		Řádek 53:
	\|		\|
	\|-		\|-
	\|CreatedDate		\|@CreatedDate
	\|datetime		\|datetime
	\|		\|
Řádek 65:		Řádek 59:
	\|		\|
	\|-		\|-
	\|UpdatedDate		\|@UpdatedDate
	\|datetime		\|datetime
	\|		\|
Řádek 71:		Řádek 65:
	\|		\|
	\|-		\|-
	\|SupplierItemName		\|@SupplierItemName
	\|nvarchar(150)		\|nvarchar(150)
	\|		\|
Řádek 77:		Řádek 71:
	\|		\|
	\|-		\|-
	\|SupplierProductCode		\|@SupplierProductCode
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
Řádek 83:		Řádek 77:
	\|		\|
	\|-		\|-
	\|Prefix		\|@Prefix
	\|nvarchar(3)		\|nvarchar(3)
	\|		\|
Řádek 89:		Řádek 83:
	\|		\|
	\|-		\|-
	\|ManufacturerSupplier		\|@ManufacturerSupplier
	\|nvarchar(50)		\|nvarchar(50)
	\|		\|
Řádek 95:		Řádek 89:
	\|		\|
	\|-		\|-
	\|ForeignPrice		\|@ForeignPrice
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
Řádek 101:		Řádek 95:
	\|		\|
	\|-		\|-
	\|RetailPrice		\|@RetailPrice
	\|decimal(18,6)		\|decimal(18,6)
	\|		\|
Řádek 110:		Řádek 104:
	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	EXEC [~~API_CreateBranch~~] @~~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_CreateProduct] @SupplierID= 2 ,@GroupID= 14 ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@Prefix= '' ,@SupplierItemName= 'SupplierItemName' ,@MinimumOrderableQuantity= 1 ,@ForeignPrice= 110 ,@BasicPrice= 190
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 7. 8. 2017, 07:08

2017-08-07T07:08:14Z

← Starší verze		Verze z 7. 8. 2017, 07:08
Řádek 18:		Řádek 18:
	\|ID		\|ID
	\|int		\|int
			\|
	\|Internal system id		\|Internal system id
	\|		\|
Řádek 23:		Řádek 24:
	\|GroupID		\|GroupID
	\|int		\|int
			\|
	\|		\|
	\|API_GetProductGroups.ID		\|API_GetProductGroups.ID
Řádek 28:		Řádek 30:
	\|SupplierID		\|SupplierID
	\|int		\|int
			\|
	\|SupplierID		\|SupplierID
	\|API_GetCustomers.ID		\|API_GetCustomers.ID
Řádek 33:		Řádek 36:
	\|ProductCode		\|ProductCode
	\|nvarchar(40)		\|nvarchar(40)
			\|
	\|Product code		\|Product code
	\|		\|
Řádek 38:		Řádek 42:
	\|TypeID		\|TypeID
	\|int		\|int
			\|
	\|TypeID.		\|TypeID.
	1 - products		1 - products
Řádek 44:		Řádek 49:
	\|MinimumOrderableQuantity		\|MinimumOrderableQuantity
	\|decimal(18,2)		\|decimal(18,2)
			\|
	\|Minimum orderable quantity		\|Minimum orderable quantity
	\|		\|
Řádek 49:		Řádek 55:
	\|BasicPrice		\|BasicPrice
	\|decimal(18,6)		\|decimal(18,6)
			\|
	\|Basic price		\|Basic price
	\|		\|
Řádek 54:		Řádek 61:
	\|CreatedDate		\|CreatedDate
	\|datetime		\|datetime
			\|
	\|Created date		\|Created date
	\|		\|
Řádek 59:		Řádek 67:
	\|UpdatedDate		\|UpdatedDate
	\|datetime		\|datetime
			\|
	\|Updated date		\|Updated date
	\|		\|
Řádek 64:		Řádek 73:
	\|SupplierItemName		\|SupplierItemName
	\|nvarchar(150)		\|nvarchar(150)
			\|
	\|Supplier item name		\|Supplier item name
	\|		\|
Řádek 69:		Řádek 79:
	\|SupplierProductCode		\|SupplierProductCode
	\|nvarchar(40)		\|nvarchar(40)
			\|
	\|Supplier product code		\|Supplier product code
	\|		\|
Řádek 74:		Řádek 85:
	\|Prefix		\|Prefix
	\|nvarchar(3)		\|nvarchar(3)
			\|
	\|Prefix		\|Prefix
	\|		\|
Řádek 79:		Řádek 91:
	\|ManufacturerSupplier		\|ManufacturerSupplier
	\|nvarchar(50)		\|nvarchar(50)
			\|
	\|Manufacturer supplier		\|Manufacturer supplier
	\|		\|
Řádek 84:		Řádek 97:
	\|ForeignPrice		\|ForeignPrice
	\|decimal(19,6)		\|decimal(19,6)
			\|
	\|Foreign price		\|Foreign price
	\|		\|
Řádek 89:		Řádek 103:
	\|RetailPrice		\|RetailPrice
	\|decimal(18,6)		\|decimal(18,6)
			\|
	\|Retail price		\|Retail price
	\|		\|

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new product in system. ==== Exact name ==== `API_CreateProduct` ==== Type ==== Standard exec…“

2017-08-07T07:07:22Z

Založena nová stránka s textem „==== Description ==== Method allows You to create new product in system. ==== Exact name ==== <code>API_CreateProduct</code> ==== Type ==== Standard exec…“

Nová stránka

==== Description ====
Method allows You to create new product in system.

==== Exact name ====
<code>API_CreateProduct</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|GroupID
|int
|
|API_GetProductGroups.ID
|-
|SupplierID
|int
|SupplierID
|API_GetCustomers.ID
|-
|ProductCode
|nvarchar(40)
|Product code
|
|-
|TypeID
|int
|TypeID.
1 - products
|
|-
|MinimumOrderableQuantity
|decimal(18,2)
|Minimum orderable quantity
|
|-
|BasicPrice
|decimal(18,6)
|Basic price
|
|-
|CreatedDate
|datetime
|Created date
|
|-
|UpdatedDate
|datetime
|Updated date
|
|-
|SupplierItemName
|nvarchar(150)
|Supplier item name
|
|-
|SupplierProductCode
|nvarchar(40)
|Supplier product code
|
|-
|Prefix
|nvarchar(3)
|Prefix
|
|-
|ManufacturerSupplier
|nvarchar(50)
|Manufacturer supplier
|
|-
|ForeignPrice
|decimal(19,6)
|Foreign price
|
|-
|RetailPrice
|decimal(18,6)
|Retail price
|
|}

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