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

2017-07-31T09:25:35Z

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

Nová stránka

==== Description ====
Method gives You overview of existing stock dispositions in system.

==== Exact name ====
<code>API_GetStockDispositions</code>

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

==== Specification ====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|StockID
|int
|ID of stock from stock list (see relation)
|API_GetStocks.ID
|-
|ProductID
|int
|ID of product from products list (see relation)
|API_GetProducts.ID
|-
|MinimumQuantity
|numeric(18,4)
|Minimum quantity
|
|-
|MaximumQuantity
|numeric(18,4)
|Maximum quantity
|
|-
|IsArchived
|int
|Is archived
|
|-
|OnStockQuantity
|decimal(10,3)
|On stock quantity
|
|-
|FullStockPrice
|decimal(18,4)
|Full stock price
|
|-
|PricePerPiece
|decimal(18,4)
|Price per piece
|
|-
|WarehousePosition
|nvarchar(50)
|Warehouse position
|
|-
|ReservedQuantity
|decimal(18,2)
|Reserved quantity
|
|-
|LastInDate
|datetime
|LastIn date
|
|-
|LastOutDate
|datetime
|Last out date
|
|-
|LastChangeDate
|datetime
|Last change date
|
|}

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

==== Notices ====
None.

API GetStockDispositions - Historie editací

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing stock dispositions in system. ==== Exact name ==== API_GetStockDispositions ====…“

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