https://podpora.nextis.cz/index.php?action=history&feed=atom&title=API_CreateProductService 2026-05-06T20:34:32Z Historie editací této stránky MediaWiki 1.28.2 https://podpora.nextis.cz/index.php?title=API_CreateProductService&diff=2332&oldid=prev 2019-11-05T15:07:42Z

<p>Založena nová stránka s textem „==== Description ==== Method allows You to create new product service in system. ==== Exact name ==== &lt;code&gt;API_CreateProductService&lt;/code&gt; ==== Type ===…“</p> <p><b>Nová stránka</b></p><div>==== Description ====<br /> Method allows You to create new product service in system.<br /> <br /> ==== Exact name ====<br /> &lt;code&gt;API_CreateProductService&lt;/code&gt;<br /> <br /> ==== Type ====<br /> Standard executable stored procedure.<br /> <br /> ==== Specification ====<br /> {| class=&quot;wikitable&quot;<br /> !Parameter<br /> !Data type<br /> !Value range<br /> !Description<br /> !Relation<br /> |-<br /> |@ProductCode<br /> |nvarchar(40) <br /> |<br /> |Product code<br /> |<br /> |-<br /> |@Name<br /> |nvarchar(150) <br /> |<br /> |Name<br /> |<br /> |-<br /> |@Description<br /> |nvarchar(250) <br /> |<br /> |Description<br /> |<br /> |-<br /> |@UnitID<br /> |int <br /> |<br /> |ID of unit from units list (see relation)<br /> |API_GetUnits.ID<br /> |-<br /> |@VATRate<br /> |int <br /> |<br /> |ID of VAT rates from VAT rates list (see relation)<br /> |API_GetVATRates.ID<br /> |-<br /> |@EshopHide<br /> |int<br /> |<br /> |Eshop hide: <br /> 0 = show, 1 = hide <br /> |<br /> |-<br /> |@RetailPrice<br /> |decimal(19,6) <br /> |<br /> |Retail price<br /> |<br /> |}<br /> <br /> ==== Return ====<br /> 0 : OK<br /> 100 : Item could not be created<br /> <br /> ==== Example ====<br /> &lt;syntaxhighlight lang=&quot;sql&quot;&gt;<br /> DECLARE @return_value int<br /> EXEC @return_value = [API_CreateProductService] @ProductCode = 'Transport', @Name = 'Transport 10', @Description = '', @UnitID = 148, @VATRate = 16028, @EshopHide = 0, @RetailPrice = 10<br /> &lt;/syntaxhighlight&gt;<br /> <br /> ==== Notices ====<br /> None.</div>

Chrzaszcz