Zobrazení zdroje stránky API GetProductService

==== Description ====
Method gives You overview of existing product service in system.

==== Exact name ====
<code>API_GetProductService</code>

==== Type ====
Standard view.

==== Specification ====
{| class="wikitable"
!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 ====
<syntaxhighlight lang="sql">
SELECT TOP 1000 * FROM [API_GetProductService]
</syntaxhighlight>

==== Notices ====
None.