API CreatePayment: Porovnání verzí
Z Podpora.nextis.cz
(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 | ||
− | | | + | |nvarchar(150) |
| | | | ||
|Note | |Note | ||
Řádka 59: | Řádka 59: | ||
|- | |- | ||
|@Purpose | |@Purpose | ||
− | | | + | |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.