API CreatePayment: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „API CreatePayment“)
 
Řádka 1: Řádka 1:
API CreatePayment
+
==== Description ====
 +
Method allows You to create new payment in system.
 +
 
 +
==== Exact name ====
 +
<code>API_CreatePayment</code>
 +
 
 +
==== Type ====
 +
Standard executable stored procedure.
 +
 
 +
==== Specification ====
 +
{| class="wikitable"
 +
!Parameter
 +
!Data type
 +
!Value range
 +
!Description
 +
!Relation
 +
|-
 +
|@DocumentID
 +
|int
 +
|
 +
|
 +
|
 +
|-
 +
|@CurrencyID
 +
|int
 +
|
 +
|
 +
|
 +
|-
 +
|@CurrencyIDInCurrency
 +
|int
 +
|
 +
|
 +
|
 +
|-
 +
|@ExchangeRate
 +
|decimal(18,6)
 +
|
 +
|
 +
|
 +
|-
 +
|@Price
 +
|decimal(19,4)
 +
|
 +
|
 +
|
 +
|-
 +
|@PriceInCurrency
 +
|decimal(18,4)
 +
|
 +
|
 +
|
 +
|-
 +
|@Note
 +
|varchar(150)
 +
|
 +
|Note
 +
|
 +
|-
 +
|@Purpose
 +
|varchar(150)
 +
|
 +
|Purpose
 +
|
 +
|}
 +
 
 +
==== Return ====
 +
0 : OK
 +
100 : Item could not be created
 +
 
 +
==== Example ====
 +
<syntaxhighlight lang="sql">
 +
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'
 +
</syntaxhighlight>
 +
 
 +
==== Notices ====
 +
None.

Verze z 30. 4. 2018, 12:36

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
@CurrencyID int
@CurrencyIDInCurrency int
@ExchangeRate decimal(18,6)
@Price decimal(19,4)
@PriceInCurrency decimal(18,4)
@Note varchar(150) Note
@Purpose varchar(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.