API GetBranches: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
 
(Není zobrazeno 5 mezilehlých verzí od 2 dalších uživatelů.)
Řádka 1: Řádka 1:
 +
==== Description ====
 +
Method gives You overview of existing branches in system.
  
−
'''API_GetBranches'''
+
==== Exact name ====
−
          ,<ID, int,>
+
<code>API_GetBranches</code>
−
          ,<WorkshopID, int,>
 
−
          ,<Name, nvarchar(100),>
 
−
          ,<Street, nvarchar(200),>
 
−
          ,<City, nvarchar(120),>
 
−
          ,<ZIPCode, nvarchar(15),>
 
−
          ,<Country, nvarchar(70),>
 
−
          ,<Region, nvarchar(70),>
 
−
          ,<State, nvarchar(80),>
 
−
          ,<StateID, int,>
 
−
          ,<Phone, nvarchar(50),>
 
−
          ,<Fax, nvarchar(50),>
 
−
          ,<MobilePhone, nvarchar(50),>
 
−
          ,<Email, nvarchar(70),>
 
−
          ,<Web, nvarchar(150),>
 
  
 +
==== Type ====
 +
Standard view.
  
 +
==== Specification ====
 +
{| class="wikitable"
 +
!Column
 +
!Data type
 +
!Description
 +
!Relation
 +
|-
 +
|ID
 +
|int
 +
|Internal system id
 +
|
 +
|-
 +
|WorkshopID
 +
|int
 +
|ID of workshop from workshop list (see relation)
 +
|API_GetWorkshops.ID
 +
|-
 +
|Name
 +
|nvarchar(100)
 +
|Branch 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
 +
|
 +
|-
 +
|Fax
 +
|nvarchar(50)
 +
|Fax
 +
|
 +
|-
 +
|MobilePhone
 +
|nvarchar(50)
 +
|Mobile phone
 +
|
 +
|-
 +
|Email
 +
|nvarchar(70)
 +
|Email
 +
|
 +
|-
 +
|Web
 +
|nvarchar(120)
 +
|Web address
 +
|
 +
|}
  
−
''Example:''
+
==== Example ====
 +
<syntaxhighlight lang="sql">
 +
SELECT TOP 1000 * FROM [API_GetBranches]
 +
</syntaxhighlight>
  
−
SELECT TOP 1000 *
+
==== Notices ====
−
 
+
None.
−
FROM [API_GetBranches]
 

Aktuální verze z 25. 7. 2017, 14:51

Description

Method gives You overview of existing branches in system.

Exact name

API_GetBranches

Type

Standard view.

Specification

Column Data type Description Relation
ID int Internal system id
WorkshopID int ID of workshop from workshop list (see relation) API_GetWorkshops.ID
Name nvarchar(100) Branch 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
Fax nvarchar(50) Fax
MobilePhone nvarchar(50) Mobile phone
Email nvarchar(70) Email
Web nvarchar(120) Web address

Example

SELECT TOP 1000 * FROM [API_GetBranches]

Notices

None.

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