API CreateProductGroup: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 22: | Řádka 22: | ||
| | | | ||
|- | |- | ||
| − | |@ | + | |@TecDocCode |
| − | |nvarchar( | + | |nvarchar(35) |
| | | | ||
| − | | | + | |TecDoc code |
| | | | ||
|- | |- | ||
| − | |@ | + | |@TecDocBrandName |
| − | | | + | |nvarchar(80) |
| | | | ||
| − | | | + | |TecDoc brand name |
| | | | ||
|- | |- | ||
| − | |@ | + | |@TecDocBrandID |
| − | | | + | |int |
| | | | ||
| − | | | + | |TecDoc brand ID |
| | | | ||
|- | |- | ||
| − | |@ | + | |@GroupName |
| − | |nvarchar( | + | |nvarchar(100) |
| | | | ||
| − | | | + | |Group name |
| | | | ||
|- | |- | ||
| − | |@ | + | |@SubGoupName |
| − | | | + | |nvarchar(100) |
| | | | ||
| − | | | + | |Sub goup name |
| | | | ||
|- | |- | ||
| − | |@ | + | |@AssortmentName |
| − | |nvarchar( | + | |nvarchar(100) |
| | | | ||
| − | | | + | |AssortmentName |
| | | | ||
|- | |- | ||
| − | |@ | + | |@Name |
| − | | | + | |nvarchar(100) |
| + | | | ||
| + | |Name | ||
| | | | ||
| − | |||
| − | |||
|- | |- | ||
| − | |@ | + | |@Name2 |
| − | | | + | |nvarchar(150) |
| | | | ||
| − | | | + | |Name 2 |
| | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|@IsNew | |@IsNew | ||
| Řádka 94: | Řádka 88: | ||
| | | | ||
|- | |- | ||
| − | |@ | + | |@SupplierID |
| − | |int | + | |int |
| + | | | ||
| + | |Supplier ID | ||
| + | |API_GetCustomers.ID | ||
| + | |- | ||
| + | |@Prefix | ||
| + | |nvarchar(3) | ||
| + | | | ||
| + | |Prefix | ||
| + | | | ||
| + | |- | ||
| + | |@SupplierProductCode | ||
| + | |nvarchar(40) | ||
| + | | | ||
| + | |Supplier product code | ||
| + | | | ||
| + | |- | ||
| + | |@ManufacturerSupplier | ||
| + | |nvarchar(50) | ||
| + | | | ||
| + | |Manufacturer supplier | ||
| + | | | ||
| + | |- | ||
| + | |@SupplierItemName | ||
| + | |nvarchar(300) | ||
| + | | | ||
| + | |Supplier item name | ||
| + | | | ||
| + | |- | ||
| + | |@BasicPrice | ||
| + | |decimal(19,6) | ||
| | | | ||
| − | | | + | |Basic price |
| | | | ||
|- | |- | ||
| − | |@ | + | |@SupplierRetailPrice |
| − | | | + | |decimal(19,6) |
| | | | ||
| − | | | + | |Supplier retail price |
| | | | ||
|- | |- | ||
| − | |@ | + | |@Description |
| − | | | + | |varchar(250) |
| | | | ||
| − | | | + | |Description |
| | | | ||
|- | |- | ||
| − | |@ | + | |@EshopDescription |
| − | |nvarchar( | + | |nvarchar(500) |
| | | | ||
| − | | | + | |Eshop description |
| | | | ||
|- | |- | ||
| − | |@ | + | |@VATRate |
|int | |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 | ||
|} | |} | ||
Verze z 7. 8. 2017, 09:37
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 | ||
| @TecDocCode | nvarchar(35) | TecDoc code | ||
| @TecDocBrandName | nvarchar(80) | TecDoc brand name | ||
| @TecDocBrandID | int | TecDoc brand ID | ||
| @GroupName | nvarchar(100) | Group name | ||
| @SubGoupName | nvarchar(100) | Sub goup name | ||
| @AssortmentName | nvarchar(100) | AssortmentName | ||
| @Name | nvarchar(100) | Name | ||
| @Name2 | nvarchar(150) | Name 2 | ||
| @IsNew | int | Is new | ||
| @PurchasePrice | decimal(18,6) | Purchase price | ||
| @RetailPrice | decimal(18,6) | Retail price | ||
| @SupplierID | int | Supplier ID | API_GetCustomers.ID | |
| @Prefix | nvarchar(3) | Prefix | ||
| @SupplierProductCode | nvarchar(40) | Supplier product code | ||
| @ManufacturerSupplier | nvarchar(50) | Manufacturer supplier | ||
| @SupplierItemName | nvarchar(300) | Supplier item name | ||
| @BasicPrice | decimal(19,6) | Basic price | ||
| @SupplierRetailPrice | decimal(19,6) | Supplier retail price | ||
| @Description | varchar(250) | Description | ||
| @EshopDescription | nvarchar(500) | Eshop description | ||
| @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 |
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.
