API GetOrderDetail: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(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…“)
 
 
(Není zobrazena jedna mezilehlá verze od stejného uživatele.)
Řádka 22: Řádka 22:
 
|OrderID
 
|OrderID
 
|int
 
|int
−
|
+
|ID of order from orders list (see relation)
−
|
+
|API_GetOrders.ID
 
|-
 
|-
 
|ProductID
 
|ProductID
 
|int
 
|int
−
|
+
|ID of product from products list (see relation)
−
|
+
|API_GetProducts.ID
 
|-
 
|-
 
|UnitID
 
|UnitID
 
|int
 
|int
−
|
+
|ID of unit from units list (see relation)
−
|
+
|API_GetUnits.ID
 
|-
 
|-
 
|CodeInLanguage
 
|CodeInLanguage
 
|nvarchar(350)
 
|nvarchar(350)
−
|
+
|Code in language
 
|
 
|
 
|-
 
|-
 
|NameInLanguage
 
|NameInLanguage
 
|nvarchar(1000)
 
|nvarchar(1000)
−
|
+
|Name in language
 
|
 
|
 
|-
 
|-
 
|Quantity
 
|Quantity
 
|decimal(12,4)
 
|decimal(12,4)
−
|
+
|Quantity
 
|
 
|
 
|-
 
|-
 
|DeliveredQuantity
 
|DeliveredQuantity
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Delivered quantity
 
|
 
|
 
|-
 
|-
 
|CanceledQuantity
 
|CanceledQuantity
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Canceled quantity
 
|
 
|
 
|-
 
|-
 
|PricePerPiece
 
|PricePerPiece
 
|decimal(19,6)
 
|decimal(19,6)
−
|
+
|Price per piece
 
|
 
|
 
|-
 
|-
 
|TotalPrice
 
|TotalPrice
 
|decimal(19,6)
 
|decimal(19,6)
−
|
+
|Total price
 
|
 
|
 
|-
 
|-
 
|PricePerPieceInCurrency
 
|PricePerPieceInCurrency
 
|decimal(19,6)
 
|decimal(19,6)
−
|
+
|Price per pieceIn currency
 
|
 
|
 
|-
 
|-
 
|TotalPriceInCurrency
 
|TotalPriceInCurrency
 
|decimal(19,6)
 
|decimal(19,6)
−
|
+
|Total price in currency
 
|
 
|
 
|-
 
|-
 
|Note
 
|Note
 
|varchar(400)
 
|varchar(400)
−
|
+
|Note
 
|
 
|
 
|-
 
|-
 
|DiscountPercent
 
|DiscountPercent
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Discount percent
 
|
 
|
 
|-
 
|-
 
|DiscountPrice
 
|DiscountPrice
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Discount price
 
|
 
|
 
|-
 
|-
 
|PricePerPieceAfterDIscount
 
|PricePerPieceAfterDIscount
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Price per piece after dIscount
 
|
 
|
 
|-
 
|-
 
|TotalPriceAfterDiscount
 
|TotalPriceAfterDiscount
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Total price after discount
 
|
 
|
 
|-
 
|-
 
|ItemTypeID
 
|ItemTypeID
 
|int
 
|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
 
|ItemText
 
|nvarchar(1000)
 
|nvarchar(1000)
−
|
+
|Item text
 
|
 
|
 
|-
 
|-
 
|DontOrder
 
|DontOrder
 
|int
 
|int
−
|
+
|Dont order
 +
 
 +
0 - Order
 +
 
 +
1 - Don't order
 
|
 
|
 
|-
 
|-
 
|PricePerPieceAfterDiscountInCurrency
 
|PricePerPieceAfterDiscountInCurrency
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Price per piece after discountIn currency
 
|
 
|
 
|-
 
|-
 
|TotalPriceAfterDiscountInCurrency
 
|TotalPriceAfterDiscountInCurrency
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Total price after discountIn currency
 
|
 
|
 
|-
 
|-
 
|DiscountPriceInCurrency
 
|DiscountPriceInCurrency
 
|decimal(18,4)
 
|decimal(18,4)
−
|
+
|Discount priceIn currency
 
|
 
|
 
|}
 
|}

Aktuální verze z 8. 8. 2017, 10:28

Description

Method gives You overview of existing order detail in system.

Exact name

API_GetOrderDetail

Type

Standard view.

Specification

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

SELECT TOP 1000 * FROM [API_GetOrderDetail]

Notices

None.

Citováno z „https://podpora.nextis.cz/index.php?title=API_GetOrderDetail&oldid=498“