API GetPayments
Z Podpora.nextis.cz
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.
