API GetWorkshops

Z Podpora.nextis.cz
Přejít na: navigace, hledání

Description

Method gives You overview of existing workshops in system

Exact name

API_GetWorkshops

Type

Standard view.

Specification

Column Data type Description Relation
ID int Internal system id
Name nvarchar(100) Workshop 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
PhoneNumber nvarchar(50) Phone number
Fax nvarchar(50) Fax
MobilePhone nvarchar(50) Mobile phone
Email nvarchar(70) Email
Web nvarchar(120) Web address

Example

SELECT TOP 1000 * FROM [API_GetWorkshops]

Notices

None.