API CreateProductGroup: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „==== Description ==== Method allows You to create new branch in system. ==== Exact name ==== <code>API_CreateBranch</code> ==== Type ==== Standard execut…“)
 
Řádka 15: Řádka 15:
 
!Description
 
!Description
 
!Relation
 
!Relation
−
 
+
|-
 +
|ProductCode
 +
|nvarchar(40)
 +
|Product code
 +
|
 +
|-
 +
|Name
 +
|nvarchar(100)
 +
|Name
 +
|
 +
|-
 +
|Description
 +
|varchar(250)
 +
|Description
 +
|
 +
|-
 +
|EshopDescription
 +
|nvarchar(500)
 +
|Eshop description
 +
|
 +
|-
 +
|TecDocCode
 +
|nvarchar(35)
 +
|TecDoc code
 +
|
 +
|-
 +
|TecDocBrandID
 +
|int
 +
|TecDoc brand ID
 +
|
 +
|-
 +
|TecDocBrandName
 +
|nvarchar(80)
 +
|TecDoc brand name
 +
|
 +
|-
 +
|VATRate
 +
|int
 +
|ID of VAT rates from VAT rates list (see relation)
 +
|API_GetVATRates.ID
 +
|-
 +
|MinimumOrderablePieces
 +
|decimal(18,2)
 +
|Minimum orderable pieces
 +
|
 +
|-
 +
|UnitID
 +
|int
 +
|ID of unit from units list (see relation)
 +
|API_GetUnits.ID
 +
|-
 +
|IsNew
 +
|int
 +
|Is new
 +
|
 +
|-
 +
|PurchasePrice
 +
|decimal(18,6)
 +
|Purchase price
 +
|
 +
|-
 +
|RetailPrice
 +
|decimal(18,6)
 +
|Retail price
 +
|
 +
|-
 +
|GroupID
 +
|int
 +
|GroupID
 +
|
 +
|-
 +
|GroupName
 +
|nvarchar(100)
 +
|Group name
 +
|
 +
|-
 +
|SubGroupID
 +
|int
 +
|SubGroupID
 +
|
 +
|-
 +
|SubGoupName
 +
|nvarchar(100)
 +
|Sub goup name
 +
|
 +
|-
 +
|AssortmentID
 +
|int
 +
|AssortmentID
 +
|
 +
|-
 +
|AssortmentName
 +
|nvarchar(100)
 +
|AssortmentName
 +
|
 
|}
 
|}
  

Verze z 7. 8. 2017, 07:44

Description

Method allows You to create new branch in system.

Exact name

API_CreateBranch

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
ProductCode nvarchar(40) Product code
Name nvarchar(100) Name
Description varchar(250) Description
EshopDescription nvarchar(500) Eshop description
TecDocCode nvarchar(35) TecDoc code
TecDocBrandID int TecDoc brand ID
TecDocBrandName nvarchar(80) TecDoc brand name
VATRate int ID of VAT rates from VAT rates list (see relation) API_GetVATRates.ID
MinimumOrderablePieces decimal(18,2) Minimum orderable pieces
UnitID int ID of unit from units list (see relation) API_GetUnits.ID
IsNew int Is new
PurchasePrice decimal(18,6) Purchase price
RetailPrice decimal(18,6) Retail price
GroupID int GroupID
GroupName nvarchar(100) Group name
SubGroupID int SubGroupID
SubGoupName nvarchar(100) Sub goup name
AssortmentID int AssortmentID
AssortmentName nvarchar(100) AssortmentName

Example

EXEC [API_CreateBranch] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'

Notices

None.

Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateProductGroup&oldid=447“