API CreateProductGroup
Z Podpora.nextis.cz
Description
Method allows You to create new branch in system.
Exact name
API_CreateBranch
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_CreateBranch] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
Notices
None.
