API GetStocks: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „Description Method gives You overview of existing stocks in system“) |
|||
| (Nejsou zobrazeny 2 mezilehlé verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 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 | ||
| + | |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==== | ||
| + | <syntaxhighlight lang="sql"> | ||
| + | SELECT TOP 1000 * FROM [API_GetStocks] | ||
| + | </syntaxhighlight> | ||
| + | ====Notices==== | ||
| + | <span> </span> | ||
| + | |||
| + | None. | ||
Aktuální verze z 9. 11. 2018, 15: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.
