API GetBranches: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
Řá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
 +
|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, 18: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“