API CreateProductGroup: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 15: | Řádek 15: | ||
!Description | !Description | ||
!Relation | !Relation | ||
! | |||
|- | |- | ||
|ProductCode | |ProductCode | ||
|nvarchar(40) | |nvarchar(40) | ||
| | |||
|Product code | |Product code | ||
| | | | ||
| Řádek 23: | Řádek 25: | ||
|Name | |Name | ||
|nvarchar(100) | |nvarchar(100) | ||
| | |||
|Name | |Name | ||
| | | | ||
| Řádek 28: | Řádek 31: | ||
|Description | |Description | ||
|varchar(250) | |varchar(250) | ||
| | |||
|Description | |Description | ||
| | | | ||
| Řádek 33: | Řádek 37: | ||
|EshopDescription | |EshopDescription | ||
|nvarchar(500) | |nvarchar(500) | ||
| | |||
|Eshop description | |Eshop description | ||
| | | | ||
| Řádek 38: | Řádek 43: | ||
|TecDocCode | |TecDocCode | ||
|nvarchar(35) | |nvarchar(35) | ||
| | |||
|TecDoc code | |TecDoc code | ||
| | | | ||
| Řádek 43: | Řádek 49: | ||
|TecDocBrandID | |TecDocBrandID | ||
|int | |int | ||
| | |||
|TecDoc brand ID | |TecDoc brand ID | ||
| | | | ||
| Řádek 48: | Řádek 55: | ||
|TecDocBrandName | |TecDocBrandName | ||
|nvarchar(80) | |nvarchar(80) | ||
| | |||
|TecDoc brand name | |TecDoc brand name | ||
| | | | ||
| Řádek 53: | Řádek 61: | ||
|VATRate | |VATRate | ||
|int | |int | ||
| | |||
|ID of VAT rates from VAT rates list (see relation) | |ID of VAT rates from VAT rates list (see relation) | ||
|API_GetVATRates.ID | |API_GetVATRates.ID | ||
| Řádek 58: | Řádek 67: | ||
|MinimumOrderablePieces | |MinimumOrderablePieces | ||
|decimal(18,2) | |decimal(18,2) | ||
| | |||
|Minimum orderable pieces | |Minimum orderable pieces | ||
| | | | ||
| Řádek 63: | Řádek 73: | ||
|UnitID | |UnitID | ||
|int | |int | ||
| | |||
|ID of unit from units list (see relation) | |ID of unit from units list (see relation) | ||
|API_GetUnits.ID | |API_GetUnits.ID | ||
| Řádek 68: | Řádek 79: | ||
|IsNew | |IsNew | ||
|int | |int | ||
| | |||
|Is new | |Is new | ||
| | | | ||
| Řádek 73: | Řádek 85: | ||
|PurchasePrice | |PurchasePrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| | |||
|Purchase price | |Purchase price | ||
| | | | ||
| Řádek 78: | Řádek 91: | ||
|RetailPrice | |RetailPrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| | |||
|Retail price | |Retail price | ||
| | | | ||
| Řádek 83: | Řádek 97: | ||
|GroupID | |GroupID | ||
|int | |int | ||
| | |||
|GroupID | |GroupID | ||
| | | | ||
| Řádek 88: | Řádek 103: | ||
|GroupName | |GroupName | ||
|nvarchar(100) | |nvarchar(100) | ||
| | |||
|Group name | |Group name | ||
| | | | ||
| Řádek 93: | Řádek 109: | ||
|SubGroupID | |SubGroupID | ||
|int | |int | ||
| | |||
|SubGroupID | |SubGroupID | ||
| | | | ||
| Řádek 98: | Řádek 115: | ||
|SubGoupName | |SubGoupName | ||
|nvarchar(100) | |nvarchar(100) | ||
| | |||
|Sub goup name | |Sub goup name | ||
| | | | ||
| Řádek 103: | Řádek 121: | ||
|AssortmentID | |AssortmentID | ||
|int | |int | ||
| | |||
|AssortmentID | |AssortmentID | ||
| | | | ||
| Řádek 108: | Řádek 127: | ||
|AssortmentName | |AssortmentName | ||
|nvarchar(100) | |nvarchar(100) | ||
| | |||
|AssortmentName | |AssortmentName | ||
| | | | ||
Verze z 7. 8. 2017, 06:45
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.