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