API GetBranches
Z Podpora.nextis.cz
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) | Branch 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.
