API CreateCrossNumbers: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „a“ |
Bez shrnutí editace |
||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 1: | ||
==== Description ==== | |||
Method allows You to create new cross number in system. | |||
==== Exact name ==== | |||
<code>API_CreateCrossNumbers</code> | |||
==== Type ==== | |||
Standard executable stored procedure. | |||
==== Specification ==== | |||
{| class="wikitable" | |||
!Parameter | |||
!Data type | |||
!Value range | |||
!Description | |||
!Relation | |||
|- | |||
|@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 | |||
|- | |||
|@TypeID | |||
|int | |||
| | |||
|TecDoc cross = 0; | |||
Laximo cross = 1; | |||
| | |||
|} | |||
==== Return ==== | |||
0 : OK | |||
100 : Item could not be created | |||
200 : Item exist | |||
==== Example ==== | |||
<syntaxhighlight lang="sql"> | |||
DECLARE @return_value int | |||
EXEC @return_value = [API_CreateCrossNumbers] @GroupID= 1 ,@Code= 'JSS110', @BrandID= 161, @BrandName= 'TRW', @TypeID= 1 | |||
</syntaxhighlight> | |||
==== Notices ==== | |||
None. | |||
Aktuální verze z 16. 4. 2019, 10:18
Description
Method allows You to create new cross number in system.
Exact name
API_CreateCrossNumbers
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @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 | |
| @TypeID | int | TecDoc cross = 0;
Laximo cross = 1; |
Return
0 : OK 100 : Item could not be created 200 : Item exist
Example
DECLARE @return_value int
EXEC @return_value = [API_CreateCrossNumbers] @GroupID= 1 ,@Code= 'JSS110', @BrandID= 161, @BrandName= 'TRW', @TypeID= 1
Notices
None.