API CreateProductGroup

Z Podpora.nextis.cz
Přejít na: navigace, hledání

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
@Name nvarchar(100) Name
@Description varchar(250) Description
@EshopDescription nvarchar(500) Eshop description
@TecDocCode nvarchar(35) TecDoc code
@TecDocBrandID int TecDoc brand ID
@TecDocBrandName nvarchar(80) TecDoc brand name
@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
@IsNew int Is new
@PurchasePrice decimal(18,6) Purchase price
@RetailPrice decimal(18,6) Retail price
@GroupID int GroupID
@GroupName nvarchar(100) Group name
@SubGroupID int SubGroupID
@SubGoupName nvarchar(100) Sub goup name
@AssortmentID int AssortmentID
@AssortmentName nvarchar(100) AssortmentName

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.