API GetProductGroups: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Add IsHiddenOnEshop |
||
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádek 31: | Řádek 31: | ||
|- | |- | ||
|Name2 | |Name2 | ||
| | |nvarchar(150) | ||
|Name 2 | |Name 2 | ||
| | | | ||
|- | |- | ||
|Description | |Description | ||
| | |nvarchar(250) | ||
|Description | |Description | ||
| | | | ||
| Řádek 77: | Řádek 77: | ||
|IsNew | |IsNew | ||
|int | |int | ||
|Is new | |Is new: | ||
0 = Off, | |||
1 = On | |||
| | | | ||
|- | |- | ||
| Řádek 92: | Řádek 95: | ||
|GroupID | |GroupID | ||
|int | |int | ||
| | |Group ID | ||
| | | | ||
|- | |- | ||
| Řádek 102: | Řádek 105: | ||
|SubGroupID | |SubGroupID | ||
|int | |int | ||
| | |Sub group ID | ||
| | | | ||
|- | |- | ||
| Řádek 112: | Řádek 115: | ||
|AssortmentID | |AssortmentID | ||
|int | |int | ||
| | |Assortment ID | ||
| | | | ||
|- | |- | ||
| Řádek 128: | Řádek 131: | ||
|datetime | |datetime | ||
|Archiving date | |Archiving date | ||
| | |||
|- | |||
|IsSale | |||
|bit | |||
|Is sale: | |||
0 = Off, | |||
1 = On | |||
| | |||
|- | |||
|IsHiddenOnEshop | |||
|bit | |||
|Is hidden on eshop: | |||
0 = Off, | |||
1 = On | |||
| | | | ||
|} | |} | ||
Aktuální verze z 19. 2. 2020, 10:26
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 | nvarchar(150) | Name 2 | |
| Description | nvarchar(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:
0 = Off, 1 = On |
|
| PurchasePrice | decimal(18,6) | Purchase price | |
| RetailPrice | decimal(18,6) | Retail price | |
| GroupID | int | Group ID | |
| GroupName | nvarchar(100) | Group name | |
| SubGroupID | int | Sub group ID | |
| SubGoupName | nvarchar(100) | Sub goup name | |
| AssortmentID | int | Assortment ID | |
| AssortmentName | nvarchar(100) | Assortment name | |
| IsArchiving | int | Is archiving | |
| ArchivingDate | datetime | Archiving date | |
| IsSale | bit | Is sale:
0 = Off, 1 = On |
|
| IsHiddenOnEshop | bit | Is hidden on eshop:
0 = Off, 1 = On |
Example
SELECT TOP 1000 * FROM [API_GetProductGroups]
Notices
None.