USP_PDACCOUNTCODESUBLEDGER_UPDATEENTRY

Adds/updates a system-defined entry in the PDACCOUNTCODEMAPSUBLEDGER table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@SUBLEDGER	nvarchar(25)	IN
@SUBLEDGERTYPE	tinyint	IN
@DESCRIPTION	nvarchar(100)	IN
@TSLONG	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_PDACCOUNTCODESUBLEDGER_UPDATEENTRY(
    @ID uniqueidentifier,
    @SUBLEDGER nvarchar(25),
    @SUBLEDGERTYPE tinyint,        
    @DESCRIPTION nvarchar(100),
    @TSLONG int=0,            
    @CHANGEAGENTID uniqueidentifier = NULL
)
as
begin

declare @CHANGEDATE datetime;

exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CHANGEDATE = getdate();        

if (select count(ID) from dbo.PDACCOUNTCODEMAPSUBLEDGER where ID = @ID) = 0
    insert into dbo.PDACCOUNTCODEMAPSUBLEDGER(ID, SUBLEDGER, SUBLEDGERTYPE, DESCRIPTION, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values(@ID, @SUBLEDGER, @SUBLEDGERTYPE, @DESCRIPTION,@CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)
else
    update dbo.PDACCOUNTCODEMAPSUBLEDGER
        set     SUBLEDGER = @SUBLEDGER, 
             SUBLEDGERTYPE = @SUBLEDGERTYPE,
             DESCRIPTION = @DESCRIPTION,             
             CHANGEDBYID = @CHANGEAGENTID,
             DATECHANGED = @CHANGEDATE
        where ID = @ID;

return 0
end