API GetStocks: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
 
Řádka 28: Řádka 28:
 
|-
 
|-
 
|Description
 
|Description
|varchar(500)
+
|nvarchar(500)
 
|Description
 
|Description
 
|
 
|
 
|-
 
|-
 
|EshopName
 
|EshopName
|nchar(30)
+
|nvarchar(30)
 
|Eshop name
 
|Eshop name
 
|
 
|

Aktuální verze z 9. 11. 2018, 16: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.