API UpdateVATRate

Description

Method allows You to update VAT rate in system.

Exact name

API_UpdateVATRate

Type

Standard executable stored procedure.

Specification

Parameter	Data type	Value range	Description	Relation
@ID	int		Internal system id
@Name	nvarchar(50)		Name
@Value	decimal(18,2)		Value
@IsActive	int		Is active

Return

0 : OK
100 : Item could not be updated

Example

DECLARE @return_value int
DECLARE @ID int
DECLARE @Name nvarchar(50)
DECLARE @Value decimal(18,2)
DECLARE @IsActive int
 
 SELECT @ID = [ID]
        @Name = [Name]
        @Value = 15
        @IsActive = [IsActive]
 FROM   [API_GetVATRates] 
 WHERE  id = 10
 
 EXECUTE @return_value = [API_UpdateVATRate] 
  @ID,
  @Name,
  @Value,
  @IsActive

Notices

None.