API GetStocks: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 1: | Řádek 1: | ||
==== Description ==== | ==== Description ==== | ||
Method gives You overview of existing stocks in system | Method gives You overview of existing stocks in system. | ||
====Exact name==== | ====Exact name==== | ||
<code>API_GetStocks</code> | <code>API_GetStocks</code> | ||
Verze z 25. 7. 2017, 13:51
Description
Method gives You overview of existing stocks in system.
Exact name
API_GetStocks
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) | Stock name | |
| Description | varchar(500) | Description | |
| EshopName | nchar(30) | Eshop name | |
| BranchID | int | ID of branch from branch list (see relation) | API_GetBranches.ID |
| IsVisibleOnEshop | int | Is visible on eshop |
Example
SELECT TOP 1000 * FROM [API_GetStocks]
Notices
None.