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…“) |
|||
| Řádka 36: | Řádka 36: | ||
|- | |- | ||
|Currency | |Currency | ||
| − | | | + | |nvarchar(5) |
|Code of currency from currency list (see relation) | |Code of currency from currency list (see relation) | ||
|API_GetCurrency.Code | |API_GetCurrency.Code | ||
| Řádka 56: | Řádka 56: | ||
|- | |- | ||
|Note | |Note | ||
| − | | | + | |nvarchar(150) |
|Note | |Note | ||
| | | | ||
|- | |- | ||
|Purpose | |Purpose | ||
| − | | | + | |nvarchar(150) |
|Purpose | |Purpose | ||
| | | | ||
|- | |- | ||
|InvoiceNumber | |InvoiceNumber | ||
| − | | | + | |nvarchar(50) |
|DocumentNumber of invoices from invoices list (see relation) | |DocumentNumber of invoices from invoices list (see relation) | ||
|API_GetInvoices.DocumentNumber | |API_GetInvoices.DocumentNumber | ||
Aktuální verze z 9. 11. 2018, 14:24
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 | nvarchar(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 | nvarchar(150) | Note | |
| Purpose | nvarchar(150) | Purpose | |
| InvoiceNumber | nvarchar(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.
