API CreatePayment: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
 
(Není zobrazena jedna mezilehlá verze od stejného uživatele.)
Řádka 19: Řádka 19:
 
|int
 
|int
 
|
 
|
|
+
|ID of invoices from invoices list (see relation)
|
+
|API_GetInvoices.ID
 
|-
 
|-
 
|@CurrencyID
 
|@CurrencyID
 
|int
 
|int
 
|
 
|
|
+
|ID of currency from currency list (see relation)
|
+
|API_GetCurrency.ID
 
|-
 
|-
 
|@CurrencyIDInCurrency
 
|@CurrencyIDInCurrency
 
|int
 
|int
 
|
 
|
|
+
|ID of currency from currency list (see relation)
|
+
|API_GetCurrency.ID
 
|-
 
|-
 
|@ExchangeRate
 
|@ExchangeRate
 
|decimal(18,6)
 
|decimal(18,6)
 
|
 
|
|
+
|Exchange rate
 
|
 
|
 
|-
 
|-
Řádka 43: Řádka 43:
 
|decimal(19,4)
 
|decimal(19,4)
 
|
 
|
|
+
|Price
 
|
 
|
 
|-
 
|-
Řádka 49: Řádka 49:
 
|decimal(18,4)
 
|decimal(18,4)
 
|
 
|
|
+
|Price in currency
 
|
 
|
 
|-
 
|-
 
|@Note
 
|@Note
|varchar(150)
+
|nvarchar(150)
 
|
 
|
 
|Note
 
|Note
Řádka 59: Řádka 59:
 
|-
 
|-
 
|@Purpose
 
|@Purpose
|varchar(150)
+
|nvarchar(150)
 
|
 
|
 
|Purpose
 
|Purpose

Aktuální verze z 9. 11. 2018, 14:23

Description

Method allows You to create new payment in system.

Exact name

API_CreatePayment

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@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
@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

Return

0 : OK
100 : Item could not be created

Example

 DECLARE @return_value int
 EXEC @return_value = [API_CreatePayment] @DocumentID = 1, @CurrencyID = 144, @CurrencyIDInCurrency = 15907, @ExchangeRate = 0.0394, @Price = 19238.578680, @PriceInCurrency = 758.000000, @Note = 'Note', @Purpose = 'Purpose'

Notices

None.