Zobrazení zdroje stránky API GetOrderDetail

==== Description ====
Method gives You overview of existing order detail in system.

==== Exact name ====
<code>API_GetOrderDetail</code>

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

==== Specification ====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|OrderID
|int
|ID of order from orders list (see relation)
|API_GetOrders.ID
|-
|ProductID
|int
|ID of product from products list (see relation)
|API_GetProducts.ID
|-
|UnitID
|int
|ID of unit from units list (see relation)
|API_GetUnits.ID
|-
|CodeInLanguage
|nvarchar(350)
|Code in language
|
|-
|NameInLanguage
|nvarchar(1000)
|Name in language
|
|-
|Quantity
|decimal(12,4)
|Quantity
|
|-
|DeliveredQuantity
|decimal(18,4)
|Delivered quantity
|
|-
|CanceledQuantity
|decimal(18,4)
|Canceled quantity
|
|-
|PricePerPiece
|decimal(19,6)
|Price per piece
|
|-
|TotalPrice
|decimal(19,6)
|Total price
|
|-
|PricePerPieceInCurrency
|decimal(19,6)
|Price per pieceIn currency
|
|-
|TotalPriceInCurrency
|decimal(19,6)
|Total price in currency
|
|-
|Note
|varchar(400)
|Note
|
|-
|DiscountPercent
|decimal(18,4)
|Discount percent
|
|-
|DiscountPrice
|decimal(18,4)
|Discount price
|
|-
|PricePerPieceAfterDIscount
|decimal(18,4)
|Price per piece after dIscount
|
|-
|TotalPriceAfterDiscount
|decimal(18,4)
|Total price after discount
|
|-
|ItemTypeID
|int
|Item type ID

-1 - _NA

1 - Goods

2 - Service

3 - Property

4 - Consumption

5 - Material

7 - Other

10 - CashAdvanceIncome

9 - CashAdvancePayment

12 - Cenina

15 - Discount

999 - Round

21 - AdvancePayment

30 - SimpleProduct

31 - Product

500 - CreditNote

600 - Bonus
|
|-
|ItemText
|nvarchar(1000)
|Item text
|
|-
|DontOrder
|int
|Dont order

0 - Order

1 - Don't order
|
|-
|PricePerPieceAfterDiscountInCurrency
|decimal(18,4)
|Price per piece after discountIn currency
|
|-
|TotalPriceAfterDiscountInCurrency
|decimal(18,4)
|Total price after discountIn currency
|
|-
|DiscountPriceInCurrency
|decimal(18,4)
|Discount priceIn currency
|
|}

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

==== Notices ====
None.