API GetStocks: Porovnání verzí
Z Podpora.nextis.cz
| (Není zobrazena jedna 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==== | ====Exact name==== | ||
<code>API_GetStocks</code> | <code>API_GetStocks</code> | ||
| Řádka 28: | Řádka 28: | ||
|- | |- | ||
|Description | |Description | ||
| − | | | + | |nvarchar(500) |
|Description | |Description | ||
| | | | ||
|- | |- | ||
|EshopName | |EshopName | ||
| − | | | + | |nvarchar(30) |
|Eshop name | |Eshop name | ||
| | | | ||
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.
