API GetCrossNumbers: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „a“ |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 1: | ||
==== Description ==== | |||
Method gives You overview of existing cross numbers in system. | |||
==== Exact name ==== | |||
<code>API_GetCrossNumbers</code> | |||
==== Type ==== | |||
Standard view. | |||
==== Specification ==== | |||
{| class="wikitable" | |||
!Column | |||
!Data type | |||
!Description | |||
!Relation | |||
|- | |||
|ID | |||
|int | |||
|Internal system id | |||
| | |||
|- | |||
|GroupID | |||
|int | |||
|Group ID | |||
|API_GetProductGroups.ID | |||
|- | |||
|Code | |||
|nvarchar(35) | |||
|TecDoc code | |||
or Laximo code | |||
| | |||
|- | |||
|BrandID | |||
|int | |||
|Brand ID | |||
|API_GetTecDocBrands.ID | |||
or API_GetLaximoBrands.ID | |||
|- | |||
|BrandName | |||
|nvarchar(80) | |||
|Brand name | |||
|API_GetTecDocBrands.Name | |||
or API_GetLaximoBrands.Name | |||
|- | |||
|DateCreated | |||
|date | |||
|Date created | |||
| | |||
|- | |||
|DateUpdated | |||
|date | |||
|Date updated | |||
| | |||
|- | |||
|TypeID | |||
|int | |||
|Type ID | |||
|TecDoc cross = 0; | |||
Laximo cross = 1; | |||
|} | |||
==== Example ==== | |||
<syntaxhighlight lang="sql"> | |||
SELECT TOP 1000 * FROM [API_GetCrossNumbers] | |||
</syntaxhighlight> | |||
==== Notices ==== | |||
None. | |||
Aktuální verze z 16. 4. 2019, 09:53
Description
Method gives You overview of existing cross numbers in system.
Exact name
API_GetCrossNumbers
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| GroupID | int | Group ID | API_GetProductGroups.ID |
| Code | nvarchar(35) | TecDoc code
or Laximo code |
|
| BrandID | int | Brand ID | API_GetTecDocBrands.ID
or API_GetLaximoBrands.ID |
| BrandName | nvarchar(80) | Brand name | API_GetTecDocBrands.Name
or API_GetLaximoBrands.Name |
| DateCreated | date | Date created | |
| DateUpdated | date | Date updated | |
| TypeID | int | Type ID | TecDoc cross = 0;
Laximo cross = 1; |
Example
SELECT TOP 1000 * FROM [API_GetCrossNumbers]
Notices
None.