API GetPayments: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method gives You overview of existing payments in system. ==== Exact name ==== <code>API_GetPayments</code> ==== Type ==== Standard…“) |
(Žádný rozdíl)
|
Verze z 30. 4. 2018, 14:52
Description
Method gives You overview of existing payments in system.
Exact name
API_GetPayments
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | API_GetPayments.ID |
| DocumentID | int | ID of invoices from invoices list (see relation) | API_GetInvoices.ID |
| CurrencyID | int | ID of currency from currency list (see relation) | API_GetCurrency.ID |
| CurrencyIDInCurrency | int | ID of currency from currency list (see relation) | API_GetCurrency.ID |
| Currency | varchar(5) | Code of currency from currency list (see relation) | API_GetCurrency.Code |
| ExchangeRate | decimal(18,6) | Exchange rate | |
| Price | decimal(19,4) | Price | |
| PriceInCurrency | decimal(18,4) | Price in currency | |
| Note | varchar(150) | Note | |
| Purpose | varchar(150) | Purpose | |
| InvoiceNumber | varchar(50) | DocumentNumber of invoices from invoices list (see relation) | API_GetInvoices.DocumentNumber |
| Date | smalldatetime | Last change date |
Example
SELECT TOP 1000 * FROM [API_GetPayments]
Notices
None.
