API CreateProductService

Description

Method allows You to create new product service in system.

Exact name

API_CreateProductService

Type

Standard executable stored procedure.

Specification

Parameter	Data type	Value range	Description	Relation
@ProductCode	nvarchar(40)		Product code
@Name	nvarchar(150)		Name
@Description	nvarchar(250)		Description
@UnitID	int		ID of unit from units list (see relation)	API_GetUnits.ID
@VATRate	int		ID of VAT rates from VAT rates list (see relation)	API_GetVATRates.ID
@EshopHide	int		Eshop hide: 0 = show, 1 = hide
@RetailPrice	decimal(19,6)		Retail price

Return

0 : OK
100 : Item could not be created

Example

 DECLARE @return_value int
 EXEC @return_value = [API_CreateProductService] @ProductCode = 'Transport', @Name = 'Transport 10', @Description = '', @UnitID = 148, @VATRate = 16028, @EshopHide = 0, @RetailPrice = 10

Notices

None.