API GetProductGroups - Historie editací

Chrzaszcz: Add IsHiddenOnEshop

2020-02-19T10:26:59Z

Add IsHiddenOnEshop

Chrzaszcz v 22. 7. 2019, 07:51

2019-07-22T07:51:38Z

Chrzaszcz v 9. 11. 2018, 13:45

2018-11-09T13:45:49Z

Chrzaszcz v 28. 9. 2017, 13:11

2017-09-28T13:11:49Z

Chrzaszcz v 28. 9. 2017, 13:10

2017-09-28T13:10:01Z

Chrzaszcz v 8. 8. 2017, 07:18

2017-08-08T07:18:28Z

Chrzaszcz v 31. 7. 2017, 09:04

2017-07-31T09:04:04Z

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.

@@ Řádka 133: / Řádka 133: @@
+|
 |-
-|@IsSale
+|IsSale
 |bit
 |Is sale:
 = Off,

@@ Řádka 77: / Řádka 77: @@
 |IsNew
 |int
-|Is new
+|Is new:
+|
 |-
@@ Řádka 128: / Řádka 131: @@
 |datetime
 |Archiving date
+|
 |}

@@ Řádka 31: / Řádka 31: @@
 |-
 |Name2
-|varchar(150)
+|nvarchar(150)
 |Name 2
+|
 |-
 |Description
-|varchar(250)
+|nvarchar(250)
 |Description
+|

@@ Řádka 92: / Řádka 92: @@
 |GroupID
 |int
-|GroupID
+|Group ID
+|
 |-
@@ Řádka 102: / Řádka 102: @@
 |SubGroupID
 |int
-|SubGroupID
+|Sub group ID
+|
 |-
@@ Řádka 112: / Řádka 112: @@
 |AssortmentID
 |int
-|AssortmentID
+|Assortment ID
+|
 |-

@@ Řádka 117: / Řádka 117: @@
 |AssortmentName
 |nvarchar(100)
-|AssortmentName
+|Assortment name
+|
 |}

@@ Řádka 57: / Řádka 57: @@
 |VATRate
 |int
+|ID of VAT rates from VAT rates list (see relation)
 |API_GetVATRates.ID
 |-
@@ Řádka 67: / Řádka 67: @@
 |UnitID
 |int
+|ID of unit from units list (see relation)
 |API_GetUnits.ID
 |-