API GetDocumentItems: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method gives You overview of existing document items in system. ==== Exact name ==== <code>API_GetDocumentItems</code> ==== Type ==…“) |
(Žádný rozdíl)
|
Verze z 31. 7. 2017, 08:15
Description
Method gives You overview of existing document items in system.
Exact name
API_GetDocumentItems
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| ReceiptID | int | ReceiptID | |
| DocumentID | int | DocumentID | |
| DocumentID2 | int | DocumentID2 | |
| ProductID | int | ProductID | |
| StorageCardID | int | StorageCardID | |
| MeasureUnitID | int | MeasureUnitID | |
| VATID | int | VATID | |
| TypeID | int | TypeID | |
| IssueQuantity | numeric(12,4) | Issue quantity | |
| RetailPricePerPiece | decimal(18,4) | Retail price per piece | |
| PurchPrice | decimal(19,4) | Purch price | |
| PurchasePriceInCurrency | decimal(19,4) | Purchase price in currency | |
| TotalPrice | decimal(19,2) | Total price | |
| TotalPriceInCurrency | decimal(19,2) | Total price in currency | |
| DiscountPercent | decimal(6,2) | Discount percent | |
| DiscountPrice | decimal(18,2) | Discount price | |
| DiscountPriceInCurrency | decimal(18,2) | Discount price in currency | |
| PurchasePriceAfterDiscount | decimal(18,4) | Purchase price after discount | |
| PurchasePriceAfterDiscountInCurrency | decimal(18,4) | Purchase price after discount in currency | |
| TotalPriceAfterDiscount | decimal(18,2) | Total price after discount | |
| TotalPriceAfterDiscountInCurrency | decimal(18,2) | Total price after discount in currency | |
| PerPiecePurchasePrice | decimal(18,6) | Per piece purchase price | |
| PerPieceVATPrice | decimal(18,4) | Per piece VAT price | |
| TotalPriceWithVAT | decimal(18,2) | Total price with VAT | |
| TotalPriceWithVATInCurrency | decimal(18,2) | Total price with VAT in currency | |
| VATRate | numeric(6,2) | VAT rate | |
| ExchangeRate | decimal(19,4) | Exchange rate | |
| VATTypeID | int | VATTypeID | |
| VATSetted | int | VAT setted | |
| VATSettedDate | datetime | VAT setted date | |
| Note | nvarchar(100) | Note | |
| AvailableStockQuantity | decimal(18,3) | Available stock quantity | |
| StockClosed | int | Stock closed | |
| OriginItemID | int | OriginItemID | |
| ReturnID | int | ReturnID | |
| ReturnItemID | int | ReturnItemID | |
| ActionPrice | int | Action price
0 - normal price 1 - action price |
|
| Name2 | nvarchar(200) | Name 2 |
Example
SELECT TOP 1000 * FROM [API_GetDocumentItems]
Notices
None.
