API GetProviderInformations: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „Description Method gives You overview of existing provider informations in system Exact name API_GetProviderInformations Type Standard view. Specification“)
 
Řádka 1: Řádka 1:
−
Description
+
==== Description ====
 
Method gives You overview of existing provider informations in system
 
Method gives You overview of existing provider informations in system
  
−
Exact name
+
==== Exact name ====
 
API_GetProviderInformations
 
API_GetProviderInformations
  
−
Type
+
==== Type ====
 
Standard view.
 
Standard view.
  
−
Specification
+
==== Specification ====
 +
{| class="wikitable"
 +
!Column
 +
!Data type
 +
!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====
 +
<syntaxhighlight lang="sql">
 +
SELECT TOP 1000 * FROM [API_GetProviderInformations]
 +
</syntaxhighlight>
 +
====Notices====
 +
<span> </span>
 +
 
 +
None.

Verze z 25. 7. 2017, 14:54

Description

Method gives You overview of existing provider informations in system

Exact name

API_GetProviderInformations

Type

Standard view.

Specification

Column Data type 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

SELECT TOP 1000 * FROM [API_GetProviderInformations]

Notices

None.

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