API GetBranches: Porovnání verzí

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

Zavadil (diskuse | příspěvky)

2 uživatelské skupiny
138 editací
VizuálníWikitext
Bez shrnutí editace
Bez shrnutí editace
Řá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
|Workshop ID
(could be equal to ID in Your internal system)
|API_GetWorkshops.ID
|-
|Name
|nvarchar(100)
|Workshop name
|
|-
|Street
|nvarchar(200)
|
|
|-
|City
|nvarchar(120)
|
|
|-
|ZIPCode
|nvarchar(15)
|
|
|-
|Country
|nvarchar(70)
|
|
|-
|Region
|nvarchar(70)
|
|
|-
|State
|nvarchar(80)
|
|
|-
|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.

Verze z 24. 7. 2017, 16:25

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 Workshop ID

(could be equal to ID in Your internal system)

API_GetWorkshops.ID
Name nvarchar(100) Workshop name
Street nvarchar(200)
City nvarchar(120)
ZIPCode nvarchar(15)
Country nvarchar(70)
Region nvarchar(70)
State nvarchar(80)
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=223“