API GetBranches: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 22: | Řádka 22: | ||
|WorkshopID | |WorkshopID | ||
|int | |int | ||
| − | | | + | |ID of workshop from workshop list (see relation) |
| − | ( | ||
|API_GetWorkshops.ID | |API_GetWorkshops.ID | ||
|- | |- | ||
| Řádka 33: | Řádka 32: | ||
|Street | |Street | ||
|nvarchar(200) | |nvarchar(200) | ||
| − | | | + | |Street |
| | | | ||
|- | |- | ||
|City | |City | ||
|nvarchar(120) | |nvarchar(120) | ||
| − | | | + | |City |
| | | | ||
|- | |- | ||
|ZIPCode | |ZIPCode | ||
|nvarchar(15) | |nvarchar(15) | ||
| − | | | + | |ZIPCode |
| | | | ||
|- | |- | ||
|Country | |Country | ||
|nvarchar(70) | |nvarchar(70) | ||
| − | | | + | |Country |
| | | | ||
|- | |- | ||
|Region | |Region | ||
|nvarchar(70) | |nvarchar(70) | ||
| − | | | + | |Region |
| | | | ||
|- | |- | ||
|State | |State | ||
|nvarchar(80) | |nvarchar(80) | ||
| − | | | + | |State |
| | | | ||
|- | |- | ||
Verze z 25. 7. 2017, 13:16
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 | ID of workshop from workshop list (see relation) | API_GetWorkshops.ID |
| Name | nvarchar(100) | Branch name | |
| Street | nvarchar(200) | Street | |
| City | nvarchar(120) | City | |
| ZIPCode | nvarchar(15) | ZIPCode | |
| 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 |
| 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.
