Chrzaszcz v 8. 8. 2017, 09:28

2017-08-08T09:28:30Z

← Starší verze		Verze z 8. 8. 2017, 09:28
Řádek 111:		Řádek 111:
	-1 - _NA		-1 - _NA

	1 - ~~Zbozi~~		1 - Goods

	2 - ~~Sluzba~~		2 - Service

	3 - ~~Majetek~~		3 - Property

	4 - ~~Spotreba~~		4 - Consumption

	5 - Material		5 - Material

	7 - ~~Ostatni~~		7 - Other

	10 - ~~ASTZaloha_Prijem~~		10 - CashAdvanceIncome

	9 - ~~ASTZaloha_Vydej~~		9 - CashAdvancePayment

	12 - Cenina		12 - Cenina

	15 - ~~Sleva~~		15 - Discount

	999 - ~~Korekce~~		999 - Round

	21 - ~~ZalohovaPlatba~~		21 - AdvancePayment

	30 - ~~VyrobekJednoduchy~~		30 - SimpleProduct

	31 - ~~Vyrobek~~		31 - Product

	500 - ~~KorekceCeny~~		500 - CreditNote

	600 - Bonus		600 - Bonus
Řádek 155:		Řádek 155:
	0 - Order		0 - Order

	1 - ~~Dont~~ order		1 - Don't order
	\|		\|
	\|-		\|-

Chrzaszcz v 8. 8. 2017, 09:13

2017-08-08T09:13:48Z

Ukázat změny

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.

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…“