API CreateProductGroup: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
 
(Není zobrazeno 7 mezilehlých verzí od stejného uživatele.)
Řádka 15: Řádka 15:
 
!Description
 
!Description
 
!Relation
 
!Relation
−
!
 
 
|-
 
|-
 
|@ProductCode
 
|@ProductCode
Řádka 23: Řádka 22:
 
|
 
|
 
|-
 
|-
−
|@Name
+
|@TecDocCode
−
|nvarchar(100)  
+
|nvarchar(35)  
 
|
 
|
−
|Name
+
|TecDoc code
 
|
 
|
 
|-
 
|-
−
|@Description
+
|@TecDocBrandName
−
|varchar(250)  
+
|nvarchar(80)  
 
|
 
|
−
|Description
+
|TecDoc brand name
 
|
 
|
 
|-
 
|-
−
|@EshopDescription
+
|@TecDocBrandID
−
|nvarchar(500)
+
|int
 
|
 
|
−
|Eshop description
+
|TecDoc brand ID
 
|
 
|
 
|-
 
|-
−
|@TecDocCode
+
|@GroupName
−
|nvarchar(35)  
+
|nvarchar(100)  
 
|
 
|
−
|TecDoc code
+
|Group name
 
|
 
|
 
|-
 
|-
−
|@TecDocBrandID
+
|@SubGoupName
−
|int
+
|nvarchar(100)
 
|
 
|
−
|TecDoc brand ID
+
|Sub goup name
 
|
 
|
 
|-
 
|-
−
|@TecDocBrandName
+
|@AssortmentName
−
|nvarchar(80)  
+
|nvarchar(100)  
 
|
 
|
−
|TecDoc brand name
+
|AssortmentName
 
|
 
|
 
|-
 
|-
−
|@VATRate
+
|@Name
−
|int
+
|nvarchar(100)
 +
|
 +
|Name
 
|
 
|
−
|ID of VAT rates from VAT rates list (see relation)
 
−
|API_GetVATRates.ID
 
 
|-
 
|-
−
|@MinimumOrderablePieces
+
|@Name2
−
|decimal(18,2)  
+
|nvarchar(150)
 
|
 
|
−
|Minimum orderable pieces
+
|Name 2
 
|
 
|
−
|-
 
−
|@UnitID
 
−
|int
 
−
|
 
−
|ID of unit from units list (see relation)
 
−
|API_GetUnits.ID
 
 
|-
 
|-
 
|@IsNew
 
|@IsNew
 
|int  
 
|int  
 
|
 
|
−
|Is new
+
|Is new:
 +
0 = Off,
 +
 
 +
1 = On
 
|
 
|
 
|-
 
|-
Řádka 95: Řádka 91:
 
|
 
|
 
|-
 
|-
−
|@GroupID
+
|@SupplierID
−
|int  
+
|int
 +
|
 +
|Supplier ID
 +
|API_GetCustomers.ID
 +
|-
 +
|@Prefix
 +
|nvarchar(3)
 +
|
 +
|Prefix
 +
|
 +
|-
 +
|@SupplierProductCode
 +
|nvarchar(40)
 +
|
 +
|Supplier product code
 +
|
 +
|-
 +
|@ManufacturerSupplier
 +
|nvarchar(50)
 +
|
 +
|Manufacturer supplier
 +
|
 +
|-
 +
|@SupplierItemName
 +
|nvarchar(300)
 +
|
 +
|Supplier item name
 +
|
 +
|-
 +
|@BasicPrice
 +
|decimal(19,6)
 +
|
 +
|Basic price
 +
|
 +
|-
 +
|@SupplierRetailPrice
 +
|decimal(19,6)
 +
|
 +
|Supplier retail price
 +
|
 +
|-
 +
|@Description
 +
|nvarchar(250)
 
|
 
|
−
|GroupID
+
|Description
 
|
 
|
 
|-
 
|-
−
|@GroupName
+
|@EshopDescription
−
|nvarchar(100)  
+
|nvarchar(500)  
 
|
 
|
−
|Group name
+
|Eshop description
 
|
 
|
 
|-
 
|-
−
|@SubGroupID
+
|@VATRate
 
|int  
 
|int  
 
|
 
|
−
|SubGroupID
+
|ID of VAT rates from VAT rates list (see relation)
 +
|API_GetVATRates.ID
 +
|-
 +
|@MinimumOrderablePieces
 +
|decimal(18,2)
 +
|
 +
|Minimum orderable pieces
 +
|
 +
|-
 +
|@UnitID
 +
|int
 
|
 
|
 +
|ID of unit from units list (see relation)
 +
|API_GetUnits.ID
 
|-
 
|-
−
|@SubGoupName
+
|@IsSale
−
|nvarchar(100)
+
|bit
 
|
 
|
−
|Sub goup name
+
|Is sale:
 +
0 = Off,
 +
 
 +
1 = On
 
|
 
|
 
|-
 
|-
−
|@AssortmentID
+
|@IsHiddenOnEshop
−
|int
+
|bit
 
|
 
|
−
|AssortmentID
+
|Is hidden on eshop:
 +
0 = Off,
 +
 
 +
1 = On
 
|
 
|
 
|-
 
|-
−
|@AssortmentName
+
|@InfoReturnOfGoods
−
|nvarchar(100)  
+
|nvarchar(50)  
 
|
 
|
−
|AssortmentName
+
|Info return of goods
 
|
 
|
 
|}
 
|}
 +
 +
==== Return ====
 +
0 : OK
 +
100 : Item could not be created
  
 
==== Example ====
 
==== Example ====
 
<syntaxhighlight lang="sql">
 
<syntaxhighlight lang="sql">
−
EXEC [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148
+
DECLARE @return_value int
 +
EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148, @IsSale= 0, @IsHiddenOnEshop = 0, @InfoReturnOfGoods = ''
 
</syntaxhighlight>
 
</syntaxhighlight>
  
 
==== Notices ====
 
==== Notices ====
 
None.
 
None.

Aktuální verze z 13. 8. 2020, 09:28

Description

Method allows You to create new product group in system.

Exact name

API_CreateProductGroup

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ProductCode nvarchar(40) Product code
@TecDocCode nvarchar(35) TecDoc code
@TecDocBrandName nvarchar(80) TecDoc brand name
@TecDocBrandID int TecDoc brand ID
@GroupName nvarchar(100) Group name
@SubGoupName nvarchar(100) Sub goup name
@AssortmentName nvarchar(100) AssortmentName
@Name nvarchar(100) Name
@Name2 nvarchar(150) Name 2
@IsNew int Is new:

0 = Off,

1 = On

@PurchasePrice decimal(18,6) Purchase price
@RetailPrice decimal(18,6) Retail price
@SupplierID int Supplier ID API_GetCustomers.ID
@Prefix nvarchar(3) Prefix
@SupplierProductCode nvarchar(40) Supplier product code
@ManufacturerSupplier nvarchar(50) Manufacturer supplier
@SupplierItemName nvarchar(300) Supplier item name
@BasicPrice decimal(19,6) Basic price
@SupplierRetailPrice decimal(19,6) Supplier retail price
@Description nvarchar(250) Description
@EshopDescription nvarchar(500) Eshop description
@VATRate int ID of VAT rates from VAT rates list (see relation) API_GetVATRates.ID
@MinimumOrderablePieces decimal(18,2) Minimum orderable pieces
@UnitID int ID of unit from units list (see relation) API_GetUnits.ID
@IsSale bit Is sale:

0 = Off,

1 = On

@IsHiddenOnEshop bit Is hidden on eshop:

0 = Off,

1 = On

@InfoReturnOfGoods nvarchar(50) Info return of goods

Return

0 : OK
100 : Item could not be created

Example

 DECLARE @return_value int
 EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148, @IsSale= 0, @IsHiddenOnEshop = 0, @InfoReturnOfGoods = ''

Notices

None.

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