API CreatePayment: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „API CreatePayment“) |
|||
| Řádka 1: | Řádka 1: | ||
| − | + | ==== 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.
