API GetProducts - Historie editací

Chrzaszcz v 13. 8. 2020, 08:26

2020-08-13T08:26:03Z

Chrzaszcz v 28. 9. 2017, 13:10

2017-09-28T13:10:28Z

Chrzaszcz v 31. 7. 2017, 09:15

2017-07-31T09:15:12Z

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

2017-07-31T09:11:48Z

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

Nová stránka

==== Description ====
Method gives You overview of existing products in system.

==== Exact name ====
<code>API_GetProducts</code>

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

==== Specification ====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|GroupID
|int
|GroupID
|
|-
|SupplierID
|int
|SupplierID
|
|-
|ProductCode
|nvarchar(40)
|Product code
|
|-
|TypeID
|int
|TypeID
|
|-
|MinimumOrderableQuantity
|decimal(18,2)
|Minimum orderable quantity
|
|-
|BasicPrice
|decimal(18,6)
|Basic price
|
|-
|CreatedDate
|datetime
|Created date
|
|-
|UpdatedDate
|datetime
|Updated date
|
|-
|SupplierItemName
|nvarchar(150)
|Supplier item name
|
|-
|SupplierProductCode
|nvarchar(40)
|Supplier product code
|
|-
|Prefix
|nvarchar(3)
|Prefix
|
|-
|ManufacturerSupplier
|nvarchar(50)
|Manufacturer supplier
|
|-
|ForeignPrice
|decimal(19,6)
|Foreign price
|
|-
|RetailPrice
|decimal(18,6)
|Retail price
|
|}

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

==== Notices ====
None.

@@ Řádka 99: / Řádka 99: @@
 |datetime
 |Archiving date
+|
 |}

@@ Řádka 89: / Řádka 89: @@
 |decimal(18,6)
 |Retail price
+|
 |}

@@ Řádka 22: / Řádka 22: @@
 |GroupID
 |int
+|
 |-
 |SupplierID
 |int
 |SupplierID
+|API_GetCustomers.ID
 |-
 |ProductCode
@@ Řádka 37: / Řádka 37: @@
 |TypeID
 |int
-|TypeID
+|TypeID.
+|
 |-

API GetProducts - Historie editací

Chrzaszcz v 13. 8. 2020, 08:26

Chrzaszcz v 28. 9. 2017, 13:10

Chrzaszcz v 31. 7. 2017, 09:15

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

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