USP_IDMAPPER_REVERSEDCHARGE_TO_RECEIVABLECREDIT

Parameters

Parameter	Parameter Type	Mode	Description
@SOURCEID	uniqueidentifier	IN
@TARGETID	uniqueidentifier	INOUT

Definition

Copy



            CREATE procedure  dbo.USP_IDMAPPER_REVERSEDCHARGE_TO_RECEIVABLECREDIT(@SOURCEID uniqueidentifier,@TARGETID uniqueidentifier output)
            as
                set nocount on;

                select
                    @TARGETID=FTLI_CR.FINANCIALTRANSACTIONID
                from
                    dbo.CHARGERECEIVABLECREDITLINEITEMS CHCRLI
          inner join dbo.FINANCIALTRANSACTIONLINEITEM FTLI_CH on CHCRLI.CHARGELINEITEMID=FTLI_CH.ID          
          inner join dbo.FINANCIALTRANSACTIONLINEITEM FTLI_CR on CHCRLI.RECEIVABLECREDITLINEITEMID=FTLI_CR.ID          
                where
                    FTLI_CH.FINANCIALTRANSACTIONID=@SOURCEID AND FTLI_CH.TYPECODE=0 AND FTLI_CH.DELETEDON is null AND FTLI_CR.TYPECODE=0 AND FTLI_CR.DELETEDON is null;

                return 0;