API CreateProduct

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

Description

Method allows You to create new product in system.

Exact name

API_CreateProduct

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@SupplierID int Supplier ID API_GetCustomers.ID
@GroupID int Group ID API_GetProductGroups.ID
@SupplierProductCode nvarchar(40) Supplier product code
@ManufacturerSupplier nvarchar(50) Manufacturer supplier
@Prefix nvarchar(3) Prefix
@SupplierItemName nvarchar(150) Supplier item name
@MinimumOrderableQuantity decimal(18,2) Minimum orderable quantity
@ForeignPrice decimal(19,6) Foreign price
@BasicPrice decimal(18,6) Basic price

Return

0 : OK
100 : Item could not be created

Example

 DECLARE @return_value int
 EXEC @return_value = [API_CreateProduct] @SupplierID= 2 ,@GroupID= 14 ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@Prefix= '' ,@SupplierItemName= 'SupplierItemName' ,@MinimumOrderableQuantity= 1 ,@ForeignPrice= 110 ,@BasicPrice= 190

Notices

None.