API CreateProduct - Historie editací

Chrzaszcz v 13. 8. 2020, 08:24

2020-08-13T08:24:04Z

Chrzaszcz v 22. 9. 2017, 08:36

2017-09-22T08:36:12Z

Chrzaszcz v 7. 8. 2017, 07:23

2017-08-07T07:23:51Z

Chrzaszcz v 7. 8. 2017, 07:17

2017-08-07T07:17:43Z

Chrzaszcz v 7. 8. 2017, 07:08

2017-08-07T07:08:14Z

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.

@@ Řádka 68: / Řádka 68: @@
+|
 |Basic price
+|
 |}
@@ Řádka 78: / Řádka 84: @@
 <syntaxhighlight lang="sql">
   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>
 ==== Notices ====
 None.

@@ Řádka 15: / Řádka 15: @@
 !Description
 !Relation
 |-
 |@SupplierID
 |int
+|
-|SupplierID
+|Supplier ID
 |API_GetCustomers.ID
 |-
-|@ProductCode
+|@GroupID
 |int
+|
-|TypeID.
+|Group ID
-- 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
+|
 |-
@@ Řádka 71: / Řádka 52: @@
+|
 |-
-|@SupplierProductCode
+|@MinimumOrderableQuantity
-|nvarchar(40)
+|decimal(18,2)
+|
-|Supplier product code
+|Minimum orderable quantity
+|
 |-
@@ Řádka 95: / Řádka 64: @@
+|
 |-
-|@RetailPrice
+|@BasicPrice
 |decimal(18,6)
+|
-|Retail price
+|Basic price
+|
 |}

@@ Řádka 16: / Řádka 16: @@
 !Relation
 |-
-|ID
+|@GroupID
 |int
+|
@@ Řádka 28: / Řádka 22: @@
 |API_GetProductGroups.ID
 |-
-|SupplierID
+|@SupplierID
 |int
+|
@@ Řádka 34: / Řádka 28: @@
 |API_GetCustomers.ID
 |-
-|ProductCode
+|@ProductCode
 |nvarchar(40)
+|
@@ Řádka 40: / Řádka 34: @@
+|
 |-
-|TypeID
+|@TypeID
 |int
+|
@@ Řádka 47: / Řádka 41: @@
+|
 |-
-|MinimumOrderableQuantity
+|@MinimumOrderableQuantity
 |decimal(18,2)
+|
@@ Řádka 53: / Řádka 47: @@
+|
 |-
-|BasicPrice
+|@BasicPrice
 |decimal(18,6)
+|
@@ Řádka 59: / Řádka 53: @@
+|
 |-
-|CreatedDate
+|@CreatedDate
 |datetime
+|
@@ Řádka 65: / Řádka 59: @@
+|
 |-
-|UpdatedDate
+|@UpdatedDate
 |datetime
+|
@@ Řádka 71: / Řádka 65: @@
+|
 |-
-|SupplierItemName
+|@SupplierItemName
 |nvarchar(150)
+|
@@ Řádka 77: / Řádka 71: @@
+|
 |-
-|SupplierProductCode
+|@SupplierProductCode
 |nvarchar(40)
+|
@@ Řádka 83: / Řádka 77: @@
+|
 |-
-|Prefix
+|@Prefix
 |nvarchar(3)
+|
@@ Řádka 89: / Řádka 83: @@
+|
 |-
-|ManufacturerSupplier
+|@ManufacturerSupplier
 |nvarchar(50)
+|
@@ Řádka 95: / Řádka 89: @@
+|
 |-
-|ForeignPrice
+|@ForeignPrice
 |decimal(19,6)
+|
@@ Řádka 101: / Řádka 95: @@
+|
 |-
-|RetailPrice
+|@RetailPrice
 |decimal(18,6)
+|
@@ Řádka 110: / Řádka 104: @@
 ==== 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'
+EXEC [API_CreateProduct] @SupplierID= 2 ,@GroupID= 14 ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@Prefix= '' ,@SupplierItemName= 'SupplierItemName' ,@MinimumOrderableQuantity= 1 ,@ForeignPrice= 110 ,@BasicPrice= 190
 </syntaxhighlight>
 ==== Notices ====
 None.