API UpdateProviderInformations: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
Porovnání s novější verzí →

Chrzaszcz (diskuse | příspěvky)

2 uživatelské skupiny
542 editací
VizuálníWikitext
Založena nová stránka s textem „==== Description ==== Method allows You to update provider informations in system. ==== Exact name ==== <code>API_UpdateProviderInformations</code> ====…“
 
Bez shrnutí editace
Řádek 24: Řádek 24:
|Name
|Name
|nvarchar(150)
|nvarchar(150)
|
|Provider name
|Provider name
|
|
Řádek 29: Řádek 30:
|Street
|Street
|nvarchar(200)
|nvarchar(200)
|
|Street
|Street
|
|
Řádek 34: Řádek 36:
|City
|City
|nvarchar(120)
|nvarchar(120)
|
|City
|City
|
|
Řádek 39: Řádek 42:
|ZIPCode
|ZIPCode
|nvarchar(15)
|nvarchar(15)
|
|ZIP code
|ZIP code
|
|
Řádek 44: Řádek 48:
|Country
|Country
|nvarchar(70)
|nvarchar(70)
|
|Country
|Country
|
|
Řádek 49: Řádek 54:
|Region
|Region
|nvarchar(70)
|nvarchar(70)
|
|Region
|Region
|
|
Řádek 54: Řádek 60:
|State
|State
|nvarchar(80)
|nvarchar(80)
|
|State
|State
|
|
Řádek 59: Řádek 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
Řádek 64: Řádek 72:
|Phone
|Phone
|nvarchar(50)
|nvarchar(50)
|
|Phone
|Phone
|
|
Řádek 69: Řádek 78:
|Phone2
|Phone2
|nvarchar(50)
|nvarchar(50)
|
|Phone 2
|Phone 2
|
|
Řádek 74: Řádek 84:
|Fax
|Fax
|nvarchar(50)
|nvarchar(50)
|
|Fax
|Fax
|
|
Řádek 79: Řádek 90:
|MobilePhone
|MobilePhone
|nvarchar(50)
|nvarchar(50)
|
|Mobile phone
|Mobile phone
|
|
Řádek 84: Řádek 96:
|Email
|Email
|nvarchar(70)
|nvarchar(70)
|
|Email
|Email
|
|
Řádek 89: Řádek 102:
|Email2
|Email2
|nvarchar(70)
|nvarchar(70)
|
|Email 2
|Email 2
|
|
Řádek 94: Řádek 108:
|Web
|Web
|nvarchar(150)
|nvarchar(150)
|
|Web address
|Web address
|
|
Řádek 99: Řádek 114:
|CompanyRegistrationNumber
|CompanyRegistrationNumber
|nvarchar(20)
|nvarchar(20)
|
|Company registration number
|Company registration number
|
|
Řádek 104: Řádek 120:
|VATNumber
|VATNumber
|nvarchar(25)
|nvarchar(25)
|
|VAT Number
|VAT Number
|
|
Řádek 109: Řádek 126:
|VATNumber2
|VATNumber2
|char(20)
|char(20)
|
|VAT Number 2
|VAT Number 2
|
|
Řádek 114: Řádek 132:
|IsVATPayer
|IsVATPayer
|int
|int
|
|Is VAT Payer
|Is VAT Payer
|
|
Řádek 119: Řádek 138:
|FileMark
|FileMark
|nvarchar(50)
|nvarchar(50)
|
|File mark
|File mark
|
|
Řádek 124: Řádek 144:
|FileMark2
|FileMark2
|nvarchar(50)
|nvarchar(50)
|
|File mark 2
|File mark 2
|
|
Řádek 129: Řádek 150:
|FileMark3
|FileMark3
|nvarchar(50)
|nvarchar(50)
|
|File mark 3
|File mark 3
|
|
Řádek 134: Řádek 156:
|FileMark4
|FileMark4
|nvarchar(50)
|nvarchar(50)
|
|File mark 4
|File mark 4
|
|

Verze z 2. 8. 2017, 14: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“