API GetWorkshops: Porovnání verzí
Z Podpora.nextis.cz
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 1: | ||
==== Description ==== | ==== Description ==== | ||
| − | Method gives You overview of existing | + | Method gives You overview of existing workshop in system. |
====Exact name==== | ====Exact name==== | ||
<code>API_GetWorkshops</code> | <code>API_GetWorkshops</code> | ||
Aktuální verze z 25. 7. 2017, 14:52
Description
Method gives You overview of existing workshop 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 | |
| nvarchar(70) | |||
| Web | nvarchar(120) | Web address |
Example
SELECT TOP 1000 * FROM [API_GetWorkshops]
Notices
None.
