API UpdateProviderInformations

Description

Method allows You to update provider informations in system.

Exact name

API_UpdateProviderInformations

Type

Standard executable stored procedure.

Specification

Parameter	Data type	Value range	Description	Relation
@ID	int		Internal system id
@Name	nvarchar(150)		Provider name
@Street	nvarchar(200)		Street
@City	nvarchar(120)		City
@ZIPCode	nvarchar(15)		ZIP code
@Country	nvarchar(70)		Country
@Region	nvarchar(70)		Region
@State	nvarchar(80)		State
@StateID	int		ID of country from country list (see relation)	API_GetCountry.ID
@Phone	nvarchar(50)		Phone
@Phone2	nvarchar(50)		Phone 2
@Fax	nvarchar(50)		Fax
@MobilePhone	nvarchar(50)		Mobile phone
@Email	nvarchar(70)		Email
@Email2	nvarchar(70)		Email 2
@Web	nvarchar(150)		Web address
@CompanyRegistrationNumber	nvarchar(20)		Company registration number
@VATNumber	nvarchar(25)		VAT Number
@VATNumber2	char(20)		VAT Number 2
@IsVATPayer	int		Is VAT Payer
@FileMark	nvarchar(50)		File mark
@FileMark2	nvarchar(50)		File mark 2
@FileMark3	nvarchar(50)		File mark 3
@FileMark4	nvarchar(50)		File mark 4

Example

 DECLARE @ID int 
 DECLARE @Name nvarchar(150)
 DECLARE @Street nvarchar(200)
 DECLARE @City nvarchar(120)
 DECLARE @ZIPCode nvarchar(15)
 DECLARE @Country nvarchar(70)
 DECLARE @Region nvarchar(70)
 DECLARE @State nvarchar(80)
 DECLARE @StateID int
 DECLARE @Phone nvarchar(50)
 DECLARE @Phone2 nvarchar(50)
 DECLARE @Fax nvarchar(50)
 DECLARE @MobilePhone nvarchar(50)
 DECLARE @Email nvarchar(70)
 DECLARE @Email2 nvarchar(70)
 DECLARE @Web nvarchar(150)
 DECLARE @CompanyRegistrationNumber nvarchar(20)
 DECLARE @VATNumber nvarchar(25)
 DECLARE @VATNumber2 char(20)
 DECLARE @IsVATPayer int
 DECLARE @FileMark nvarchar(50)
 DECLARE @FileMark2 nvarchar(50)
 DECLARE @FileMark3 nvarchar(50)
 DECLARE @FileMark4 nvarchar(50)
 
 SELECT @ID = [ID], 
       @Name = [Name],
       @Street = [Street],
       @City = [City],
       @ZIPCode = [ZIPCode],
       @Country = [Country],
       @Region = [Region],
       @State = [State],
       @StateID = [StateID],
       @Phone = [Phone],
       @Phone2 = [Phone2],
       @Fax = [Fax],
       @MobilePhone = [MobilePhone],
       @Email = [Email],
       @Email2 = [Email2],
       @Web = [Web],
       @CompanyRegistrationNumber = [CompanyRegistrationNumber],
       @VATNumber = [VATNumber],
       @VATNumber2 = [VATNumber2],
       @IsVATPayer = [IsVATPayer],
       @FileMark = [FileMark],
       @FileMark2 = [FileMark2],
       @FileMark3 = [FileMark3],
       @FileMark4 = [FileMark4]
 FROM   [API_GetProviderInformations] 
 WHERE  id = 3
 
 EXECUTE [API_UpdateProviderInformations] 
  @ID, 
  @Name,
  @Street,
  @City,
  @ZIPCode,
  @Country,
  @Region,
  @State,
  @StateID,
  @Phone,
  @Phone2,
  @Fax,
  @MobilePhone,
  @Email,
  @Email2,
  @Web,
  @CompanyRegistrationNumber,
  @VATNumber,
  @VATNumber2,
  @IsVATPayer,
  @FileMark,
  @FileMark2,
  @FileMark3,
  @FileMark4

Notices

None.