API CreateProductGroup

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
@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	varchar(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

Example

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

Notices

None.