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