API GetProductService
Z Podpora.nextis.cz
Description
Method gives You overview of existing product service in system.
Exact name
API_GetProductService
Type
Standard view.
Specification
Column | Data type | Description | Relation |
---|---|---|---|
ID | int | Internal system id | |
ProductCode | nvarchar(40) | Name | |
Name | varchar(150) | Name | |
Description | varchar(250) | Description | |
UnitID | int | ID of unit from units list (see relation) | API_GetUnits.ID |
VATRate | int | ID of VAT rates from VAT rates list (see relation) | API_GetVATRates.ID |
EshopHide | int | Eshop hide:
0 = show, 1 = hide |
|
RetailPrice | decimal(18,6) | Retail price | |
IsArchiving | int | Is archiving | |
ArchivingDate | datetime | Archiving date |
Example
SELECT TOP 1000 * FROM [API_GetProductService]
Notices
None.