API CreatePayment - Historie editací

Chrzaszcz v 9. 11. 2018, 13:23

2018-11-09T13:23:56Z

2018-04-30T11:40:33Z

← Starší verze		Verze z 30. 4. 2018, 11:40
Řádek 19:		Řádek 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
	\|		\|
	\|-		\|-
Řádek 43:		Řádek 43:
	\|decimal(19,4)		\|decimal(19,4)
	\|		\|
	\|		\|Price
	\|		\|
	\|-		\|-
Řádek 49:		Řádek 49:
	\|decimal(18,4)		\|decimal(18,4)
	\|		\|
	\|		\|Price in currency
	\|		\|
	\|-		\|-

2018-04-30T11:36:19Z

← Starší verze		Verze z 30. 4. 2018, 11:36
Řádek 1:		Řádek 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.

2018-04-30T10:21:35Z

Založena nová stránka s textem „API CreatePayment“

Nová stránka

API CreatePayment