API GetProducts - Historie editací

Chrzaszcz v 13. 8. 2020, 08:26

2020-08-13T08:26:03Z

← Starší verze		Verze z 13. 8. 2020, 08:26
Řádek 99:		Řádek 99:
	\|datetime		\|datetime
	\|Archiving date		\|Archiving date
			\|
			\|-
			\|InfoReturnOfGoods
			\|nvarchar(50)
			\|Info return of goods
	\|		\|
	\|}		\|}

Chrzaszcz v 28. 9. 2017, 13:10

2017-09-28T13:10:28Z

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

Chrzaszcz v 31. 7. 2017, 09:15

2017-07-31T09:15:12Z

← Starší verze		Verze z 31. 7. 2017, 09:15
Řádek 22:		Řádek 22:
	\|GroupID		\|GroupID
	\|int		\|int
	~~\|GroupID~~
	\|		\|
			\|API_GetProductGroups.ID
	\|-		\|-
	\|SupplierID		\|SupplierID
	\|int		\|int
	\|SupplierID		\|SupplierID
	\|		\|API_GetCustomers.ID
	\|-		\|-
	\|ProductCode		\|ProductCode
Řádek 37:		Řádek 37:
	\|TypeID		\|TypeID
	\|int		\|int
	\|TypeID		\|TypeID.
			1 - products
	\|		\|
	\|-		\|-

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.

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…“