API GetBranches: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 1: | Řádka 1: | ||
| + | ==== Description ==== | ||
| + | Method gives You overview of existing branches in system | ||
| − | + | ==== Exact name ==== | |
| − | + | <code>API_GetBranches</code> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | ==== 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 ==== | |
| − | + | <syntaxhighlight lang="sql"> | |
| − | + | SELECT TOP 1000 * FROM [API_GetBranches] | |
| + | </syntaxhighlight> | ||
| + | |||
| + | ==== Notices ==== | ||
| + | None. | ||
Verze z 24. 7. 2017, 17: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 | |
| nvarchar(70) | |||
| Web | nvarchar(120) | Web address |
Example
SELECT TOP 1000 * FROM [API_GetBranches]
Notices
None.
