Chrzaszcz v 9. 11. 2018, 13:24

2018-11-09T13:24:26Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing payments in system. ==== Exact name ==== `API_GetPayments` ==== Type ==== Standard…“

2018-04-30T13:52:14Z

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…“

Nová stránka

==== Description ====
Method gives You overview of existing payments in system.

==== Exact name ====
<code>API_GetPayments</code>

==== Type ====
Standard view.

==== Specification ====
{| class="wikitable"
!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 ====
<syntaxhighlight lang="sql">
SELECT TOP 1000 * FROM [API_GetPayments]
</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 36: / Řádka 36: @@
 |-
 |Currency
-|varchar(5)
+|nvarchar(5)
 |Code of currency from currency list (see relation)
 |API_GetCurrency.Code
@@ Řádka 56: / Řádka 56: @@
 |-
 |Note
-|varchar(150)
+|nvarchar(150)
 |Note
+|
 |-
 |Purpose
-|varchar(150)
+|nvarchar(150)
 |Purpose
+|
 |-
 |InvoiceNumber
-|varchar(50)
+|nvarchar(50)
 |DocumentNumber of invoices from invoices list (see relation)
 |API_GetInvoices.DocumentNumber

API GetPayments - Historie editací

Chrzaszcz v 9. 11. 2018, 13:24

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing payments in system. ==== Exact name ==== API_GetPayments ==== Type ==== Standard…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing payments in system. ==== Exact name ==== `API_GetPayments` ==== Type ==== Standard…“