USP_FENXT_MERGEACCOUNTNUMBERS

Parameters

Parameter	Parameter Type	Mode
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@ACCOUNTID	int	IN
@ACCOUNTNUMBER	nvarchar(100)	IN
@DESCRIPTION	nvarchar(50)	IN
@DATEMODIFIED	datetime	IN
@ACCOUNTCLASS	nvarchar(50)	IN
@PREVENTDATAENTRY	bit	IN
@PREVENTPOSTINGDATE	date	IN
Definition

Copy


            create procedure dbo.USP_FENXT_MERGEACCOUNTNUMBERS
                (
                @PDACCOUNTSYSTEMID uniqueidentifier, 
                @ACCOUNTID int, 
                @ACCOUNTNUMBER nvarchar(100), 
                @DESCRIPTION nvarchar(50), 
                @DATEMODIFIED datetime, 
                @ACCOUNTCLASS nvarchar(50) = '',
                @PREVENTDATAENTRY bit = 0,
                @PREVENTPOSTINGDATE date = null
                )
                as

                declare @CHANGEAGENTID uniqueidentifier;
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                merge
                into dbo.FENXTACCOUNT
                using (select @PDACCOUNTSYSTEMID as PDACCOUNTSYSTEMID,
                        @ACCOUNTID as ACCOUNTID,
                        @ACCOUNTNUMBER as ACCOUNTNUMBER,
                        @DESCRIPTION as DESCRIPTION,
                        @DATEMODIFIED as DATEMODIFIED,
                        @ACCOUNTCLASS as ACCOUNTCLASS,
                        @PREVENTDATAENTRY as PREVENTDATAENTRY,
                        @PREVENTPOSTINGDATE as PREVENTPOSTINGDATE,
                        @CHANGEAGENTID as CHANGEAGENTID,
                        @CURRENTDATE as CURRENTDATE) as source
                on FENXTACCOUNT.ACCOUNTID = source.ACCOUNTID 
                    and FENXTACCOUNT.PDACCOUNTSYSTEMID = source.PDACCOUNTSYSTEMID
                when matched then
                    update
                        set ACCOUNTNUMBER = source.ACCOUNTNUMBER,
                        DESCRIPTION = source.DESCRIPTION,
                        DATEMODIFIED = source.DATEMODIFIED,
                        ACCOUNTCLASS = source.ACCOUNTCLASS,
                        PREVENTDATAENTRY = source.PREVENTDATAENTRY,
                        PREVENTPOSTINGDATE = source.PREVENTPOSTINGDATE,
                        CHANGEDBYID = source.CHANGEAGENTID,
                        DATECHANGED = source.CURRENTDATE
                when not matched then
                    insert 
                        (PDACCOUNTSYSTEMID,
                        ACCOUNTID,
                        ACCOUNTNUMBER,
                        DESCRIPTION,
                        DATEMODIFIED,
                        ACCOUNTCLASS,
                        PREVENTDATAENTRY,
                        PREVENTPOSTINGDATE,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED)
                    values
                        (source.PDACCOUNTSYSTEMID,
                        source.ACCOUNTID,
                        source.ACCOUNTNUMBER,
                        source.DESCRIPTION,
                        source.DATEMODIFIED,
                        source.ACCOUNTCLASS,
                        source.PREVENTDATAENTRY,
                        source.PREVENTPOSTINGDATE,
                        source.CHANGEAGENTID,
                        source.CHANGEAGENTID,
                        source.CURRENTDATE,
                        source.CURRENTDATE);