API CreateProductGroup: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 1: | Řádka 1: | ||
==== Description ==== | ==== Description ==== | ||
| − | Method allows You to create new | + | Method allows You to create new product group in system. |
==== Exact name ==== | ==== Exact name ==== | ||
| − | <code> | + | <code>API_CreateProductGroup</code> |
==== Type ==== | ==== Type ==== | ||
| Řádka 17: | Řádka 17: | ||
! | ! | ||
|- | |- | ||
| − | |ProductCode | + | |@ProductCode |
|nvarchar(40) | |nvarchar(40) | ||
| | | | ||
| Řádka 23: | Řádka 23: | ||
| | | | ||
|- | |- | ||
| − | |Name | + | |@Name |
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádka 29: | Řádka 29: | ||
| | | | ||
|- | |- | ||
| − | |Description | + | |@Description |
|varchar(250) | |varchar(250) | ||
| | | | ||
| Řádka 35: | Řádka 35: | ||
| | | | ||
|- | |- | ||
| − | |EshopDescription | + | |@EshopDescription |
|nvarchar(500) | |nvarchar(500) | ||
| | | | ||
| Řádka 41: | Řádka 41: | ||
| | | | ||
|- | |- | ||
| − | |TecDocCode | + | |@TecDocCode |
|nvarchar(35) | |nvarchar(35) | ||
| | | | ||
| Řádka 47: | Řádka 47: | ||
| | | | ||
|- | |- | ||
| − | |TecDocBrandID | + | |@TecDocBrandID |
|int | |int | ||
| | | | ||
| Řádka 53: | Řádka 53: | ||
| | | | ||
|- | |- | ||
| − | |TecDocBrandName | + | |@TecDocBrandName |
|nvarchar(80) | |nvarchar(80) | ||
| | | | ||
| Řádka 59: | Řádka 59: | ||
| | | | ||
|- | |- | ||
| − | |VATRate | + | |@VATRate |
|int | |int | ||
| | | | ||
| Řádka 65: | Řádka 65: | ||
|API_GetVATRates.ID | |API_GetVATRates.ID | ||
|- | |- | ||
| − | |MinimumOrderablePieces | + | |@MinimumOrderablePieces |
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádka 71: | Řádka 71: | ||
| | | | ||
|- | |- | ||
| − | |UnitID | + | |@UnitID |
|int | |int | ||
| | | | ||
| Řádka 77: | Řádka 77: | ||
|API_GetUnits.ID | |API_GetUnits.ID | ||
|- | |- | ||
| − | |IsNew | + | |@IsNew |
|int | |int | ||
| | | | ||
| Řádka 83: | Řádka 83: | ||
| | | | ||
|- | |- | ||
| − | |PurchasePrice | + | |@PurchasePrice |
|decimal(18,6) | |decimal(18,6) | ||
| | | | ||
| Řádka 89: | Řádka 89: | ||
| | | | ||
|- | |- | ||
| − | |RetailPrice | + | |@RetailPrice |
|decimal(18,6) | |decimal(18,6) | ||
| | | | ||
| Řádka 95: | Řádka 95: | ||
| | | | ||
|- | |- | ||
| − | |GroupID | + | |@GroupID |
|int | |int | ||
| | | | ||
| Řádka 101: | Řádka 101: | ||
| | | | ||
|- | |- | ||
| − | |GroupName | + | |@GroupName |
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádka 107: | Řádka 107: | ||
| | | | ||
|- | |- | ||
| − | |SubGroupID | + | |@SubGroupID |
|int | |int | ||
| | | | ||
| Řádka 113: | Řádka 113: | ||
| | | | ||
|- | |- | ||
| − | |SubGoupName | + | |@SubGoupName |
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádka 119: | Řádka 119: | ||
| | | | ||
|- | |- | ||
| − | |AssortmentID | + | |@AssortmentID |
|int | |int | ||
| | | | ||
| Řádka 125: | Řádka 125: | ||
| | | | ||
|- | |- | ||
| − | |AssortmentName | + | |@AssortmentName |
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádka 134: | Řádka 134: | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| − | EXEC [ | + | EXEC [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148 |
</syntaxhighlight> | </syntaxhighlight> | ||
==== Notices ==== | ==== Notices ==== | ||
None. | None. | ||
Verze z 7. 8. 2017, 08:04
Description
Method allows You to create new product group in system.
Exact name
API_CreateProductGroup
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_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148
Notices
None.
