API GetCrossNumbers: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 33: | Řádek 33: | ||
|int | |int | ||
|Brand ID | |Brand ID | ||
|API_GetTecDocBrands.ID or API_GetLaximoBrands.ID | |API_GetTecDocBrands.ID | ||
or API_GetLaximoBrands.ID | |||
|- | |- | ||
|BrandName | |BrandName | ||
|nvarchar(80) | |nvarchar(80) | ||
|Brand name | |Brand name | ||
|API_GetTecDocBrands.Name or API_GetLaximoBrands.Name | |API_GetTecDocBrands.Name | ||
or API_GetLaximoBrands.Name | |||
|- | |- | ||
|DateCreated | |DateCreated | ||
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.