API CreateProductGroup: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
← Porovnání se starší verzí

Chrzaszcz (diskuse | příspěvky)

2 uživatelské skupiny
542 editací
VizuálníWikitext
Bez shrnutí editace
Bez shrnutí editace
 
(Není zobrazeno 8 mezilehlých verzí od stejného uživatele.)
Řádek 1: Řádek 1:
==== Description ====
==== Description ====
Method allows You to create new branch in system.
Method allows You to create new product group in system.


==== Exact name ====
==== Exact name ====
<code>API_CreateBranch</code>
<code>API_CreateProductGroup</code>


==== Type ====
==== Type ====
Řádek 15: Řádek 15:
!Description
!Description
!Relation
!Relation
!
|-
|-
|ProductCode
|@ProductCode
|nvarchar(40)  
|nvarchar(40)  
|
|
Řádek 23: Řádek 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
|@IsNew
|int  
|int  
|
|
|ID of unit from units list (see relation)
|Is new:
|API_GetUnits.ID
0 = Off,
|-
 
|IsNew
1 = On
|int
|
|Is new
|
|
|-
|-
|PurchasePrice
|@PurchasePrice
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 89: Řádek 85:
|
|
|-
|-
|RetailPrice
|@RetailPrice
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 95: Řádek 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
|
|
|-
|-
|SubGoupName
|@UnitID
|nvarchar(100)  
|int
|
|ID of unit from units list (see relation)
|API_GetUnits.ID
|-
|@IsSale
|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_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'
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, 08: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“