API GetStocks: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řá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> | ||
| Řádek 28: | Řádek 28: | ||
|- | |- | ||
|Description | |Description | ||
| | |nvarchar(500) | ||
|Description | |Description | ||
| | | | ||
|- | |- | ||
|EshopName | |EshopName | ||
| | |nvarchar(30) | ||
|Eshop name | |Eshop name | ||
| | | | ||
Aktuální verze z 9. 11. 2018, 14:44
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 | nvarchar(500) | Description | |
| EshopName | nvarchar(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.