API GetProductGroups: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method gives You overview of existing product groups in system. ==== Exact name ==== <code>API_GetProductGroups</code> ==== Type ==…“) |
|||
| Řádka 57: | Řádka 57: | ||
|VATRate | |VATRate | ||
|int | |int | ||
| − | | | + | |ID of VAT rates from VAT rates list (see relation) |
|API_GetVATRates.ID | |API_GetVATRates.ID | ||
|- | |- | ||
| Řádka 67: | Řádka 67: | ||
|UnitID | |UnitID | ||
|int | |int | ||
| − | | | + | |ID of unit from units list (see relation) |
|API_GetUnits.ID | |API_GetUnits.ID | ||
|- | |- | ||
Verze z 31. 7. 2017, 10:04
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 | |
| 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.
