API CreateProductGroup: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „==== Description ==== Method allows You to create new branch in system. ==== Exact name ==== <code>API_CreateBranch</code> ==== Type ==== Standard execut…“ |
Bez shrnutí editace |
||
| Řádek 15: | Řádek 15: | ||
!Description | !Description | ||
!Relation | !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 | |||
| | |||
|} | |} | ||
Verze z 7. 8. 2017, 06:44
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.