API GetOrders: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method gives You overview of existing orders in system. ==== Exact name ==== <code>API_GetOrders</code> ==== Type ==== Standard vie…“) |
|||
| Řádka 18: | Řádka 18: | ||
|int | |int | ||
|Internal system id | |Internal system id | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
|- | |- | ||
Verze z 8. 8. 2017, 09:03
Description
Method gives You overview of existing orders in system.
Exact name
API_GetOrders
Type
Standard view.
Specification
| 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
SELECT TOP 1000 * FROM [API_GetOrders]
Notices
None.
