API GetProductGroups - Historie editací

Chrzaszcz: Add IsHiddenOnEshop

2020-02-19T10:26:59Z

Add IsHiddenOnEshop

← Starší verze		Verze z 19. 2. 2020, 10:26
Řádek 133:		Řádek 133:
	\|		\|
	\|-		\|-
	\|@IsSale		\|IsSale
	\|bit		\|bit
	\|Is sale:		\|Is sale:
			0 = Off,

			1 = On
			\|
			\|-
			\|IsHiddenOnEshop
			\|bit
			\|Is hidden on eshop:
	0 = Off,		0 = Off,

Chrzaszcz v 22. 7. 2019, 07:51

2019-07-22T07:51:38Z

← Starší verze		Verze z 22. 7. 2019, 07:51
Řádek 77:		Řádek 77:
	\|IsNew		\|IsNew
	\|int		\|int
	\|Is new		\|Is new:
			0 = Off,

			1 = On
	\|		\|
	\|-		\|-
Řádek 128:		Řádek 131:
	\|datetime		\|datetime
	\|Archiving date		\|Archiving date
			\|
			\|-
			\|@IsSale
			\|bit
			\|Is sale:
			0 = Off,

			1 = On
	\|		\|
	\|}		\|}

Chrzaszcz v 9. 11. 2018, 13:45

2018-11-09T13:45:49Z

← Starší verze		Verze z 9. 11. 2018, 13:45
Řádek 31:		Řádek 31:
	\|-		\|-
	\|Name2		\|Name2
	\|~~varchar~~(150)		\|nvarchar(150)
	\|Name 2		\|Name 2
	\|		\|
	\|-		\|-
	\|Description		\|Description
	\|~~varchar~~(250)		\|nvarchar(250)
	\|Description		\|Description
	\|		\|

Chrzaszcz v 28. 9. 2017, 13:11

2017-09-28T13:11:49Z

← Starší verze		Verze z 28. 9. 2017, 13:11
Řádek 92:		Řádek 92:
	\|GroupID		\|GroupID
	\|int		\|int
	\|~~GroupID~~		\|Group ID
	\|		\|
	\|-		\|-
Řádek 102:		Řádek 102:
	\|SubGroupID		\|SubGroupID
	\|int		\|int
	\|~~SubGroupID~~		\|Sub group ID
	\|		\|
	\|-		\|-
Řádek 112:		Řádek 112:
	\|AssortmentID		\|AssortmentID
	\|int		\|int
	\|~~AssortmentID~~		\|Assortment ID
	\|		\|
	\|-		\|-

Chrzaszcz v 28. 9. 2017, 13:10

2017-09-28T13:10:01Z

← Starší verze		Verze z 28. 9. 2017, 13:10
Řádek 117:		Řádek 117:
	\|AssortmentName		\|AssortmentName
	\|nvarchar(100)		\|nvarchar(100)
	\|~~AssortmentName~~		\|Assortment name
			\|
			\|-
			\|IsArchiving
			\|int
			\|Is archiving
			\|
			\|-
			\|ArchivingDate
			\|datetime
			\|Archiving date
	\|		\|
	\|}		\|}

Chrzaszcz v 8. 8. 2017, 07:18

2017-08-08T07:18:28Z

← Starší verze		Verze z 8. 8. 2017, 07:18
Řádek 28:		Řádek 28:
	\|nvarchar(100)		\|nvarchar(100)
	\|Name		\|Name
			\|
			\|-
			\|Name2
			\|varchar(150)
			\|Name 2
	\|		\|
	\|-		\|-

Chrzaszcz v 31. 7. 2017, 09:04

2017-07-31T09:04:04Z

← Starší verze		Verze z 31. 7. 2017, 09:04
Řádek 57:		Řádek 57:
	\|VATRate		\|VATRate
	\|int		\|int
	\|		\|ID of VAT rates from VAT rates list (see relation)
	\|API_GetVATRates.ID		\|API_GetVATRates.ID
	\|-		\|-
Řádek 67:		Řádek 67:
	\|UnitID		\|UnitID
	\|int		\|int
	\|		\|ID of unit from units list (see relation)
	\|API_GetUnits.ID		\|API_GetUnits.ID
	\|-		\|-

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing product groups in system. ==== Exact name ==== `API_GetProductGroups` ==== Type ==…“

2017-07-31T09:00:41Z

Založena nová stránka s textem „==== Description ==== Method gives You overview of existing product groups in system. ==== Exact name ==== <code>API_GetProductGroups</code> ==== Type ==…“

Nová stránka

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

==== Exact name ====
<code>API_GetProductGroups</code>

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

==== Specification ====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|ProductCode
|nvarchar(40)
|Product code
|
|-
|Name
|nvarchar(100)
|Name
|
|-
|Description
|varchar(250)
|Description
|
|-
|EshopDescription
|nvarchar(500)
|Eshop description
|
|-
|TecDocCode
|nvarchar(35)
|TecDoc code
|
|-
|TecDocBrandID
|int
|TecDoc brand ID
|
|-
|TecDocBrandName
|nvarchar(80)
|TecDoc brand name
|
|-
|VATRate
|int
|
|API_GetVATRates.ID
|-
|MinimumOrderablePieces
|decimal(18,2)
|Minimum orderable pieces
|
|-
|UnitID
|int
|
|API_GetUnits.ID
|-
|IsNew
|int
|Is new
|
|-
|PurchasePrice
|decimal(18,6)
|Purchase price
|
|-
|RetailPrice
|decimal(18,6)
|Retail price
|
|-
|GroupID
|int
|GroupID
|
|-
|GroupName
|nvarchar(100)
|Group name
|
|-
|SubGroupID
|int
|SubGroupID
|
|-
|SubGoupName
|nvarchar(100)
|Sub goup name
|
|-
|AssortmentID
|int
|AssortmentID
|
|-
|AssortmentName
|nvarchar(100)
|AssortmentName
|
|}

==== Example ====
<syntaxhighlight lang="sql">
SELECT TOP 1000 * FROM [API_GetProductGroups]
</syntaxhighlight>

==== Notices ====
None.