API CreateProductGroup: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 1: | Řádek 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 ==== | ||
| Řádek 17: | Řádek 17: | ||
! | ! | ||
|- | |- | ||
|ProductCode | |@ProductCode | ||
|nvarchar(40) | |nvarchar(40) | ||
| | | | ||
| Řádek 23: | Řádek 23: | ||
| | | | ||
|- | |- | ||
|Name | |@Name | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádek 29: | Řádek 29: | ||
| | | | ||
|- | |- | ||
|Description | |@Description | ||
|varchar(250) | |varchar(250) | ||
| | | | ||
| Řádek 35: | Řádek 35: | ||
| | | | ||
|- | |- | ||
|EshopDescription | |@EshopDescription | ||
|nvarchar(500) | |nvarchar(500) | ||
| | | | ||
| Řádek 41: | Řádek 41: | ||
| | | | ||
|- | |- | ||
|TecDocCode | |@TecDocCode | ||
|nvarchar(35) | |nvarchar(35) | ||
| | | | ||
| Řádek 47: | Řádek 47: | ||
| | | | ||
|- | |- | ||
|TecDocBrandID | |@TecDocBrandID | ||
|int | |int | ||
| | | | ||
| Řádek 53: | Řádek 53: | ||
| | | | ||
|- | |- | ||
|TecDocBrandName | |@TecDocBrandName | ||
|nvarchar(80) | |nvarchar(80) | ||
| | | | ||
| Řádek 59: | Řádek 59: | ||
| | | | ||
|- | |- | ||
|VATRate | |@VATRate | ||
|int | |int | ||
| | | | ||
| Řádek 65: | Řádek 65: | ||
|API_GetVATRates.ID | |API_GetVATRates.ID | ||
|- | |- | ||
|MinimumOrderablePieces | |@MinimumOrderablePieces | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| Řádek 71: | Řádek 71: | ||
| | | | ||
|- | |- | ||
|UnitID | |@UnitID | ||
|int | |int | ||
| | | | ||
| Řádek 77: | Řádek 77: | ||
|API_GetUnits.ID | |API_GetUnits.ID | ||
|- | |- | ||
|IsNew | |@IsNew | ||
|int | |int | ||
| | | | ||
| Řádek 83: | Řádek 83: | ||
| | | | ||
|- | |- | ||
|PurchasePrice | |@PurchasePrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| | | | ||
| Řádek 89: | Řádek 89: | ||
| | | | ||
|- | |- | ||
|RetailPrice | |@RetailPrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| | | | ||
| Řádek 95: | Řádek 95: | ||
| | | | ||
|- | |- | ||
|GroupID | |@GroupID | ||
|int | |int | ||
| | | | ||
| Řádek 101: | Řádek 101: | ||
| | | | ||
|- | |- | ||
|GroupName | |@GroupName | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádek 107: | Řádek 107: | ||
| | | | ||
|- | |- | ||
|SubGroupID | |@SubGroupID | ||
|int | |int | ||
| | | | ||
| Řádek 113: | Řádek 113: | ||
| | | | ||
|- | |- | ||
|SubGoupName | |@SubGoupName | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádek 119: | Řádek 119: | ||
| | | | ||
|- | |- | ||
|AssortmentID | |@AssortmentID | ||
|int | |int | ||
| | | | ||
| Řádek 125: | Řádek 125: | ||
| | | | ||
|- | |- | ||
|AssortmentName | |@AssortmentName | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádek 134: | Řádek 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, 07: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.