USP_BANKACCOUNTDEPOSIT_OVERWRITEPAYMENTDEBITACCOUNTS
Overwrite the payment's debit accounts with the bank account's default cash account
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @DEPOSITID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CHANGEDATE | datetime | IN |
Definition
Copy
CREATE procedure dbo.USP_BANKACCOUNTDEPOSIT_OVERWRITEPAYMENTDEBITACCOUNTS
(
@REVENUEID uniqueidentifier,
@DEPOSITID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@CHANGEDATE datetime = null
)
as
begin
set nocount on;
declare @XML xml
set @XML =
(select BASEAMOUNT [AMOUNT], [ID], '' [PAYMENTMETHOD], GETDATE() [TRANSACTIONDATE], '' [TRANSACTIONTYPE]
from dbo.FINANCIALTRANSACTION where ID = @REVENUEID
for xml raw('ITEM'),type,elements,root('PAYMENTS'),BINARY BASE64)
exec dbo.USP_BANKACCOUNTDEPOSIT_OVERWRITEMULTIPLEPAYMENTSDEBITACCOUNTS @DEPOSITID, @XML, @CHANGEAGENTID, @CHANGEDATE
end