API UpdateProductGroup: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 20: | Řádka 20: | ||
| | | | ||
|Internal system id | |Internal system id | ||
| − | | | + | |API_GetProductGroups.ID |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|@ProductCode | |@ProductCode | ||
|nvarchar(40) | |nvarchar(40) | ||
| | | | ||
| − | | | + | |Product code |
| | | | ||
|- | |- | ||
| Řádka 37: | Řádka 31: | ||
|nvarchar(35) | |nvarchar(35) | ||
| | | | ||
| − | | | + | |TecDoc code |
| | | | ||
|- | |- | ||
| Řádka 43: | Řádka 37: | ||
|nvarchar(80) | |nvarchar(80) | ||
| | | | ||
| − | | | + | |TecDoc brand name |
| | | | ||
|- | |- | ||
| Řádka 49: | Řádka 43: | ||
|int | |int | ||
| | | | ||
| − | | | + | |TecDoc brand ID |
| | | | ||
|- | |- | ||
| Řádka 55: | Řádka 49: | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| − | | | + | |Group name |
| | | | ||
|- | |- | ||
| Řádka 61: | Řádka 55: | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| − | | | + | |Sub goup name |
| | | | ||
|- | |- | ||
| Řádka 67: | Řádka 61: | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| − | | | + | |AssortmentName |
| | | | ||
|- | |- | ||
| Řádka 73: | Řádka 67: | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| − | | | + | |Name |
| | | | ||
|- | |- | ||
| Řádka 79: | Řádka 73: | ||
|varchar(150) | |varchar(150) | ||
| | | | ||
| − | | | + | |Name2 |
| | | | ||
|- | |- | ||
| Řádka 85: | Řádka 79: | ||
|bit | |bit | ||
| | | | ||
| − | | | + | |Is new |
| | | | ||
|- | |- | ||
| Řádka 91: | Řádka 85: | ||
|decimal(19,6) | |decimal(19,6) | ||
| | | | ||
| − | | | + | |Purchase price |
| | | | ||
|- | |- | ||
| Řádka 97: | Řádka 91: | ||
|decimal(19,6) | |decimal(19,6) | ||
| | | | ||
| − | | | + | |Retail price |
| | | | ||
|- | |- | ||
| Řádka 103: | Řádka 97: | ||
|int | |int | ||
| | | | ||
| − | | | + | |Supplier ID |
| − | | | + | |API_GetCustomers.ID |
|- | |- | ||
|@Prefix | |@Prefix | ||
|nvarchar(3) | |nvarchar(3) | ||
| | | | ||
| − | | | + | |@Prefix |
| | | | ||
|- | |- | ||
| Řádka 115: | Řádka 109: | ||
|nvarchar(40) | |nvarchar(40) | ||
| | | | ||
| − | | | + | |Supplier product code |
| | | | ||
|- | |- | ||
| Řádka 121: | Řádka 115: | ||
|nvarchar(50) | |nvarchar(50) | ||
| | | | ||
| − | | | + | |Manufacturer supplier |
| | | | ||
|- | |- | ||
| Řádka 127: | Řádka 121: | ||
|nvarchar(300) | |nvarchar(300) | ||
| | | | ||
| − | | | + | |Supplier item name |
| | | | ||
|- | |- | ||
| Řádka 133: | Řádka 127: | ||
|decimal(19,6) | |decimal(19,6) | ||
| | | | ||
| − | | | + | |Basic price |
| | | | ||
|- | |- | ||
| Řádka 139: | Řádka 133: | ||
|decimal(19,6) | |decimal(19,6) | ||
| | | | ||
| − | | | + | |Supplier retail price |
| | | | ||
|- | |- | ||
| Řádka 145: | Řádka 139: | ||
|varchar(250) | |varchar(250) | ||
| | | | ||
| − | | | + | |Description |
| | | | ||
|- | |- | ||
| Řádka 151: | Řádka 145: | ||
|nvarchar(500) | |nvarchar(500) | ||
| | | | ||
| − | | | + | |Eshop description |
| | | | ||
|- | |- | ||
| Řádka 157: | Řádka 151: | ||
|int | |int | ||
| | | | ||
| − | | | + | |ID of VAT rates from VAT rates list (see relation) |
| − | | | + | |API_GetVATRates.ID |
|- | |- | ||
|@MinimumOrderablePieces | |@MinimumOrderablePieces | ||
|decimal(18,2) | |decimal(18,2) | ||
| | | | ||
| − | | | + | |Minimum orderable pieces |
| | | | ||
|- | |- | ||
| Řádka 169: | Řádka 163: | ||
|int | |int | ||
| | | | ||
| − | | | + | |ID of unit from units list (see relation) |
| − | | | + | |API_GetUnits.ID |
|} | |} | ||
Verze z 8. 8. 2017, 09:27
Description
Method allows You to update product group in system.
Exact name
API_UpdateProductGroup
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @ID | int | Internal system id | API_GetProductGroups.ID | |
| @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 | varchar(150) | Name2 | ||
| @IsNew | bit | Is new | ||
| @PurchasePrice | decimal(19,6) | Purchase price | ||
| @RetailPrice | decimal(19,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
DECLARE @ID int
DECLARE @ProductCode nvarchar(40)
DECLARE @TecDocCode nvarchar(35)
DECLARE @TecDocBrandName nvarchar(80)
DECLARE @TecDocBrandID int
DECLARE @GroupName nvarchar(100)
DECLARE @SubGoupName nvarchar(100)
DECLARE @AssortmentName nvarchar(100)
DECLARE @Name nvarchar(100)
DECLARE @Name2 varchar(150)
DECLARE @IsNew bit
DECLARE @PurchasePrice decimal(19,6)
DECLARE @RetailPrice decimal(19,6)
DECLARE @SupplierID int
DECLARE @Prefix nvarchar(3)
DECLARE @SupplierProductCode nvarchar(40)
DECLARE @ManufacturerSupplier nvarchar(50)
DECLARE @SupplierItemName nvarchar(300)
DECLARE @BasicPrice decimal(19,6)
DECLARE @SupplierRetailPrice decimal(19,6)
DECLARE @Description varchar(250)
DECLARE @EshopDescription nvarchar(500)
DECLARE @VATRate int
DECLARE @MinimumOrderablePieces decimal(18,2)
DECLARE @UnitID int
SELECT @ID = [ID],
@ProductCode = [ProductCode],
@TecDocCode = [TecDocCode],
@TecDocBrandName = [TecDocBrandName],
@TecDocBrandID = [TecDocBrandID],
@GroupName = [GroupName],
@SubGoupName = [SubGoupName],
@AssortmentName = [AssortmentName],
@Name = 'Name 2',
@Name2 = [Name2],
@IsNew = [IsNew],
@PurchasePrice = [PurchasePrice],
@RetailPrice = [RetailPrice],
@Description = [Description],
@EshopDescription = [EshopDescription],
@VATRate = [VATRate],
@MinimumOrderablePieces = [MinimumOrderablePieces],
@UnitID = [UnitID]
FROM [API_GetProductGroups]
WHERE id = 3
SELECT @SupplierID = [SupplierID],
@Prefix = [Prefix],
@SupplierProductCode = [SupplierProductCode],
@ManufacturerSupplier = [ManufacturerSupplier],
@SupplierItemName = [SupplierItemName],
@BasicPrice = [BasicPrice],
@SupplierRetailPrice = [RetailPrice]
FROM [API_GetProducts]
WHERE GroupID = @ID and SupplierID = @SupplierID
EXECUTE [API_UpdateProductGroup]
@ID,
@ProductCode,
@TecDocCode,
@TecDocBrandName,
@TecDocBrandID,
@GroupName,
@SubGoupName,
@AssortmentName,
@Name,
@Name2,
@IsNew,
@PurchasePrice,
@RetailPrice,
@SupplierID,
@Prefix,
@SupplierProductCode,
@ManufacturerSupplier,
@SupplierItemName,
@BasicPrice,
@SupplierRetailPrice,
@Description,
@EshopDescription,
@VATRate,
@MinimumOrderablePieces,
@UnitID
Notices
None.
