API CreateProductGroup
Z Podpora.nextis.cz
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.