API UpdateProviderInformations: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „==== Description ==== Method allows You to update provider informations in system. ==== Exact name ==== <code>API_UpdateProviderInformations</code> ====…“)
 
Řádka 24: Řádka 24:
 
|Name
 
|Name
 
|nvarchar(150)
 
|nvarchar(150)
 +
|
 
|Provider name
 
|Provider name
 
|
 
|
Řádka 29: Řádka 30:
 
|Street
 
|Street
 
|nvarchar(200)
 
|nvarchar(200)
 +
|
 
|Street
 
|Street
 
|
 
|
Řádka 34: Řádka 36:
 
|City
 
|City
 
|nvarchar(120)
 
|nvarchar(120)
 +
|
 
|City
 
|City
 
|
 
|
Řádka 39: Řádka 42:
 
|ZIPCode
 
|ZIPCode
 
|nvarchar(15)
 
|nvarchar(15)
 +
|
 
|ZIP code
 
|ZIP code
 
|
 
|
Řádka 44: Řádka 48:
 
|Country
 
|Country
 
|nvarchar(70)
 
|nvarchar(70)
 +
|
 
|Country
 
|Country
 
|
 
|
Řádka 49: Řádka 54:
 
|Region
 
|Region
 
|nvarchar(70)
 
|nvarchar(70)
 +
|
 
|Region
 
|Region
 
|
 
|
Řádka 54: Řádka 60:
 
|State
 
|State
 
|nvarchar(80)
 
|nvarchar(80)
 +
|
 
|State
 
|State
 
|
 
|
Řádka 59: Řádka 66:
 
|StateID
 
|StateID
 
|int
 
|int
 +
|
 
|ID of country from country list (see relation)
 
|ID of country from country list (see relation)
 
|API_GetCountry.ID
 
|API_GetCountry.ID
Řádka 64: Řádka 72:
 
|Phone
 
|Phone
 
|nvarchar(50)
 
|nvarchar(50)
 +
|
 
|Phone
 
|Phone
 
|
 
|
Řádka 69: Řádka 78:
 
|Phone2
 
|Phone2
 
|nvarchar(50)
 
|nvarchar(50)
 +
|
 
|Phone 2
 
|Phone 2
 
|
 
|
Řádka 74: Řádka 84:
 
|Fax
 
|Fax
 
|nvarchar(50)
 
|nvarchar(50)
 +
|
 
|Fax
 
|Fax
 
|
 
|
Řádka 79: Řádka 90:
 
|MobilePhone
 
|MobilePhone
 
|nvarchar(50)
 
|nvarchar(50)
 +
|
 
|Mobile phone
 
|Mobile phone
 
|
 
|
Řádka 84: Řádka 96:
 
|Email
 
|Email
 
|nvarchar(70)
 
|nvarchar(70)
 +
|
 
|Email
 
|Email
 
|
 
|
Řádka 89: Řádka 102:
 
|Email2
 
|Email2
 
|nvarchar(70)
 
|nvarchar(70)
 +
|
 
|Email 2
 
|Email 2
 
|
 
|
Řádka 94: Řádka 108:
 
|Web
 
|Web
 
|nvarchar(150)
 
|nvarchar(150)
 +
|
 
|Web address
 
|Web address
 
|
 
|
Řádka 99: Řádka 114:
 
|CompanyRegistrationNumber
 
|CompanyRegistrationNumber
 
|nvarchar(20)
 
|nvarchar(20)
 +
|
 
|Company registration number
 
|Company registration number
 
|
 
|
Řádka 104: Řádka 120:
 
|VATNumber
 
|VATNumber
 
|nvarchar(25)
 
|nvarchar(25)
 +
|
 
|VAT Number
 
|VAT Number
 
|
 
|
Řádka 109: Řádka 126:
 
|VATNumber2
 
|VATNumber2
 
|char(20)
 
|char(20)
 +
|
 
|VAT Number 2
 
|VAT Number 2
 
|
 
|
Řádka 114: Řádka 132:
 
|IsVATPayer
 
|IsVATPayer
 
|int
 
|int
 +
|
 
|Is VAT Payer
 
|Is VAT Payer
 
|
 
|
Řádka 119: Řádka 138:
 
|FileMark
 
|FileMark
 
|nvarchar(50)
 
|nvarchar(50)
 +
|
 
|File mark
 
|File mark
 
|
 
|
Řádka 124: Řádka 144:
 
|FileMark2
 
|FileMark2
 
|nvarchar(50)
 
|nvarchar(50)
 +
|
 
|File mark 2
 
|File mark 2
 
|
 
|
Řádka 129: Řádka 150:
 
|FileMark3
 
|FileMark3
 
|nvarchar(50)
 
|nvarchar(50)
 +
|
 
|File mark 3
 
|File mark 3
 
|
 
|
Řádka 134: Řádka 156:
 
|FileMark4
 
|FileMark4
 
|nvarchar(50)
 
|nvarchar(50)
 +
|
 
|File mark 4
 
|File mark 4
 
|
 
|

Verze z 2. 8. 2017, 16:44

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.

Citováno z „https://podpora.nextis.cz/index.php?title=API_UpdateProviderInformations&oldid=414“