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.