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.
