Chrzaszcz v 5. 11. 2019, 14:54

2019-11-05T14:54:59Z

Chrzaszcz v 5. 11. 2019, 14:45

2019-11-05T14:45:39Z

2019-11-05T14:25:59Z

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

Nová stránka

@@ Řádka 47: / Řádka 47: @@
 |EshopHide
 |int
-|Eshop hide
+|Eshop hide:
+|
 |-

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