Chrzaszcz v 5. 11. 2019, 14:54

2019-11-05T14:54:59Z

Chrzaszcz v 5. 11. 2019, 14:45

2019-11-05T14:45:39Z

← Starší verze		Verze z 5. 11. 2019, 14:45
Řádek 1:		Řádek 1:
	s		==== 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
			\|
			\|-
			\|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.

2019-11-05T14:25:59Z

Založena nová stránka s textem „s“

Nová stránka