API GetBranches: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
← Porovnání se starší verzí

Chrzaszcz (diskuse | příspěvky)

2 uživatelské skupiny
542 editací
VizuálníWikitext
Bez shrnutí editace
Bez shrnutí editace
 
(Nejsou zobrazeny 4 mezilehlé verze od 2 dalších uživatelů.)
Řádek 1: Řádek 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 ====
SELECT TOP 1000 *
<syntaxhighlight lang="sql">
FROM [API_GetBranches]
SELECT TOP 1000 * FROM [API_GetBranches]
</syntaxhighlight>
 
==== Notices ====
None.

Aktuální verze z 25. 7. 2017, 13: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“