API GetStocks: Porovnání verzí
Z Podpora.nextis.cz
| Řá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> | ||
Verze z 25. 7. 2017, 14: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.
