API GetOrderDetail - Historie editací

Chrzaszcz v 8. 8. 2017, 09:28

2017-08-08T09:28:30Z

Chrzaszcz v 8. 8. 2017, 09:13

2017-08-08T09:13:48Z

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

2017-08-08T08:03:48Z

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

Nová stránka

==== 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
|
|
|-
|ProductID
|int
|
|
|-
|UnitID
|int
|
|
|-
|CodeInLanguage
|nvarchar(350)
|
|
|-
|NameInLanguage
|nvarchar(1000)
|
|
|-
|Quantity
|decimal(12,4)
|
|
|-
|DeliveredQuantity
|decimal(18,4)
|
|
|-
|CanceledQuantity
|decimal(18,4)
|
|
|-
|PricePerPiece
|decimal(19,6)
|
|
|-
|TotalPrice
|decimal(19,6)
|
|
|-
|PricePerPieceInCurrency
|decimal(19,6)
|
|
|-
|TotalPriceInCurrency
|decimal(19,6)
|
|
|-
|Note
|varchar(400)
|
|
|-
|DiscountPercent
|decimal(18,4)
|
|
|-
|DiscountPrice
|decimal(18,4)
|
|
|-
|PricePerPieceAfterDIscount
|decimal(18,4)
|
|
|-
|TotalPriceAfterDiscount
|decimal(18,4)
|
|
|-
|ItemTypeID
|int
|
|
|-
|ItemText
|nvarchar(1000)
|
|
|-
|DontOrder
|int
|
|
|-
|PricePerPieceAfterDiscountInCurrency
|decimal(18,4)
|
|
|-
|TotalPriceAfterDiscountInCurrency
|decimal(18,4)
|
|
|-
|DiscountPriceInCurrency
|decimal(18,4)
|
|
|}

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

==== Notices ====
None.

@@ Řádka 111: / Řádka 111: @@
 -1 - _NA
-- Zbozi
+- Goods
-- Sluzba
+- Service
-- Majetek
+- Property
-- Spotreba
+- Consumption
 - Material
-- Ostatni
+- Other
-- ASTZaloha_Prijem
+- CashAdvanceIncome
-- ASTZaloha_Vydej
+- CashAdvancePayment
 - Cenina
-- Sleva
+- Discount
-- Korekce
+- Round
-- ZalohovaPlatba
+- AdvancePayment
-- VyrobekJednoduchy
+- SimpleProduct
-- Vyrobek
+- Product
-- KorekceCeny
+- CreditNote
 - Bonus
@@ Řádka 155: / Řádka 155: @@
 - Order
-- Dont order
+- Don't order
+|
 |-

@@ Řádka 22: / Řádka 22: @@
 |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
+|
 |-
 |ItemText
 |nvarchar(1000)
+|Item text
+|
 |-
 |DontOrder
 |int
+|Dont 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
+|
 |}

API GetOrderDetail - Historie editací

Chrzaszcz v 8. 8. 2017, 09:28

Chrzaszcz v 8. 8. 2017, 09:13

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

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