API GetUniversalPartsCategories: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „dd“)
 
 
Řádka 1: Řádka 1:
−
dd
+
====Description====
 +
Method gives You overview of existing universal parts categories in system.
 +
====Exact name====
 +
<code>API_GetUniversalPartsCategories</code>
 +
====Type====
 +
Standard view.
 +
====Specification====
 +
{| class="wikitable"
 +
!Column
 +
!Data type
 +
!Description
 +
!Relation
 +
|-
 +
|ID
 +
|int
 +
|Internal system id
 +
|
 +
|-
 +
|ParentID
 +
|int
 +
|Parent category ID
 +
|
 +
|-
 +
|Name
 +
|nvarchar(250)
 +
|Name
 +
|
 +
|-
 +
|CreatedDate
 +
|smalldatetime
 +
|Created date
 +
|
 +
|-
 +
|Description
 +
|nvarchar(800)
 +
|Description
 +
|
 +
|-
 +
|SortIndex
 +
|int
 +
|Sort index
 +
|
 +
|-
 +
|IsRoot
 +
|bit
 +
|Is root
 +
|
 +
|-
 +
|IsTop
 +
|bit
 +
|Is top
 +
|
 +
|}
 +
====Example====
 +
<syntaxhighlight lang="sql">
 +
SELECT TOP 1000 * FROM [API_GetUniversalPartsCategories]
 +
</syntaxhighlight>
 +
====Notices====
 +
None.

Aktuální verze z 26. 7. 2017, 09:45

Description

Method gives You overview of existing universal parts categories in system.

Exact name

API_GetUniversalPartsCategories

Type

Standard view.

Specification

Column Data type Description Relation
ID int Internal system id
ParentID int Parent category ID
Name nvarchar(250) Name
CreatedDate smalldatetime Created date
Description nvarchar(800) Description
SortIndex int Sort index
IsRoot bit Is root
IsTop bit Is top

Example

SELECT TOP 1000 * FROM [API_GetUniversalPartsCategories]

Notices

None.

Citováno z „https://podpora.nextis.cz/index.php?title=API_GetUniversalPartsCategories&oldid=260“