API GetProductService

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

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
RetailPrice decimal(18,6) Retail price
IsArchiving int Is archiving
ArchivingDate datetime Archiving date

Example

SELECT TOP 1000 * FROM [API_GetProductService]

Notices

None.