API GetCrossNumbers: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „a“) |
|||
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 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, 10: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.
