API GetProductGroups

Z Podpora.nextis.cz
Přejít na: navigace, hledání

Description

Method gives You overview of existing product groups in system.

Exact name

API_GetProductGroups

Type

Standard view.

Specification

Column Data type Description Relation
ID int Internal system id
ProductCode nvarchar(40) Product code
Name nvarchar(100) Name
Name2 varchar(150) Name 2
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

SELECT TOP 1000 * FROM [API_GetProductGroups]

Notices

None.