API CreateProductGroup: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 15: | Řádka 15: | ||
!Description | !Description | ||
!Relation | !Relation | ||
| + | ! | ||
|- | |- | ||
|ProductCode | |ProductCode | ||
|nvarchar(40) | |nvarchar(40) | ||
| + | | | ||
|Product code | |Product code | ||
| | | | ||
| Řádka 23: | Řádka 25: | ||
|Name | |Name | ||
|nvarchar(100) | |nvarchar(100) | ||
| + | | | ||
|Name | |Name | ||
| | | | ||
| Řádka 28: | Řádka 31: | ||
|Description | |Description | ||
|varchar(250) | |varchar(250) | ||
| + | | | ||
|Description | |Description | ||
| | | | ||
| Řádka 33: | Řádka 37: | ||
|EshopDescription | |EshopDescription | ||
|nvarchar(500) | |nvarchar(500) | ||
| + | | | ||
|Eshop description | |Eshop description | ||
| | | | ||
| Řádka 38: | Řádka 43: | ||
|TecDocCode | |TecDocCode | ||
|nvarchar(35) | |nvarchar(35) | ||
| + | | | ||
|TecDoc code | |TecDoc code | ||
| | | | ||
| Řádka 43: | Řádka 49: | ||
|TecDocBrandID | |TecDocBrandID | ||
|int | |int | ||
| + | | | ||
|TecDoc brand ID | |TecDoc brand ID | ||
| | | | ||
| Řádka 48: | Řádka 55: | ||
|TecDocBrandName | |TecDocBrandName | ||
|nvarchar(80) | |nvarchar(80) | ||
| + | | | ||
|TecDoc brand name | |TecDoc brand name | ||
| | | | ||
| Řádka 53: | Řádka 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 | ||
| Řádka 58: | Řádka 67: | ||
|MinimumOrderablePieces | |MinimumOrderablePieces | ||
|decimal(18,2) | |decimal(18,2) | ||
| + | | | ||
|Minimum orderable pieces | |Minimum orderable pieces | ||
| | | | ||
| Řádka 63: | Řádka 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 | ||
| Řádka 68: | Řádka 79: | ||
|IsNew | |IsNew | ||
|int | |int | ||
| + | | | ||
|Is new | |Is new | ||
| | | | ||
| Řádka 73: | Řádka 85: | ||
|PurchasePrice | |PurchasePrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| + | | | ||
|Purchase price | |Purchase price | ||
| | | | ||
| Řádka 78: | Řádka 91: | ||
|RetailPrice | |RetailPrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| + | | | ||
|Retail price | |Retail price | ||
| | | | ||
| Řádka 83: | Řádka 97: | ||
|GroupID | |GroupID | ||
|int | |int | ||
| + | | | ||
|GroupID | |GroupID | ||
| | | | ||
| Řádka 88: | Řádka 103: | ||
|GroupName | |GroupName | ||
|nvarchar(100) | |nvarchar(100) | ||
| + | | | ||
|Group name | |Group name | ||
| | | | ||
| Řádka 93: | Řádka 109: | ||
|SubGroupID | |SubGroupID | ||
|int | |int | ||
| + | | | ||
|SubGroupID | |SubGroupID | ||
| | | | ||
| Řádka 98: | Řádka 115: | ||
|SubGoupName | |SubGoupName | ||
|nvarchar(100) | |nvarchar(100) | ||
| + | | | ||
|Sub goup name | |Sub goup name | ||
| | | | ||
| Řádka 103: | Řádka 121: | ||
|AssortmentID | |AssortmentID | ||
|int | |int | ||
| + | | | ||
|AssortmentID | |AssortmentID | ||
| | | | ||
| Řádka 108: | Řádka 127: | ||
|AssortmentName | |AssortmentName | ||
|nvarchar(100) | |nvarchar(100) | ||
| + | | | ||
|AssortmentName | |AssortmentName | ||
| | | | ||
Verze z 7. 8. 2017, 07: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.
