Zobrazení zdroje stránky API GetProducts

==== 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 
|
|API_GetProductGroups.ID
|-
|SupplierID
|int 
|SupplierID
|API_GetCustomers.ID
|-
|ProductCode
|nvarchar(40) 
|Product code
|
|-
|TypeID
|int 
|TypeID. 
1 - products
|
|-
|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
|
|-
|IsArchiving
|int
|Is archiving
|
|-
|ArchivingDate
|datetime
|Archiving date
|
|-
|InfoReturnOfGoods
|nvarchar(50)
|Info return of goods
|
|}

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

==== Notices ====
None.