USP_RECURRINGGIFT_ADDPAYMENTHANDLINGWRITEOFF

Parameters

Parameter	Parameter Type	Mode
@RECURRINGGIFTID	uniqueidentifier	IN
@INSTALLMENTID	uniqueidentifier	IN
@PAYMENTID	uniqueidentifier	IN
@DATE	date	IN
@AMOUNT	money	IN
@BASECURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@ORGANIZATIONEXCHANGERATEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN

Definition

Copy



create procedure dbo.USP_RECURRINGGIFT_ADDPAYMENTHANDLINGWRITEOFF (
  @RECURRINGGIFTID uniqueidentifier,
  @INSTALLMENTID uniqueidentifier,
  @PAYMENTID uniqueidentifier,
  @DATE date,
  @AMOUNT money,
  @BASECURRENCYID uniqueidentifier,
  @BASEEXCHANGERATEID uniqueidentifier,
  @TRANSACTIONCURRENCYID uniqueidentifier,
  @ORGANIZATIONEXCHANGERATEID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @CURRENTDATE datetime
)
as
begin
  declare @WRITEOFFID uniqueidentifier = newid();

  insert into dbo.RECURRINGGIFTWRITEOFF (ID, REVENUEID, DATE, REASONTYPECODE, PAYMENTID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  values (@WRITEOFFID, @RECURRINGGIFTID, @DATE, 1, @PAYMENTID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

  insert into dbo.RECURRINGGIFTINSTALLMENTWRITEOFF (
    ID,
    RECURRINGGIFTINSTALLMENTID,
    WRITEOFFID,
    AMOUNT,
    BASECURRENCYID,
    ORGANIZATIONAMOUNT,
    ORGANIZATIONEXCHANGERATEID,
    TRANSACTIONAMOUNT,
    TRANSACTIONCURRENCYID,
    BASEEXCHANGERATEID,
    ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  select
    newid(),
    @INSTALLMENTID,
    @WRITEOFFID,
    WRITEOFFAMOUNTCURRENCYVALUES.BASEAMOUNT,
    @BASECURRENCYID,
    WRITEOFFAMOUNTCURRENCYVALUES.ORGANIZATIONAMOUNT,
    @ORGANIZATIONEXCHANGERATEID,
    @AMOUNT,
    @TRANSACTIONCURRENCYID,
    @BASEEXCHANGERATEID,
    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
  from dbo.UFN_CURRENCY_GETCURRENCYVALUES_2
    (
      @AMOUNT,
      null,
      @BASECURRENCYID,
      @BASEEXCHANGERATEID,
      @TRANSACTIONCURRENCYID,
      null,
      null,
      null,
      @ORGANIZATIONEXCHANGERATEID,
      0
    ) as WRITEOFFAMOUNTCURRENCYVALUES;
end