API GetStocks: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „Description Method gives You overview of existing stocks in system“ |
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==== | |||
<code>API_GetStocks</code> | |||
====Type==== | |||
Standard view. | |||
====Specification==== | |||
{| class="wikitable" | |||
!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==== | |||
<syntaxhighlight lang="sql"> | |||
SELECT TOP 1000 * FROM [API_GetStocks] | |||
</syntaxhighlight> | |||
====Notices==== | |||
<span> </span> | |||
None. | |||
Verze z 25. 7. 2017, 13:06
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.