API GetUniversalPartsCategories: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „dd“ |
Bez shrnutí editace |
||
| Řádek 1: | Řádek 1: | ||
====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, 07: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.