USP_FENXT_ADDACCOUNTSTRUCTURE

Parameters

Parameter	Parameter Type	Mode
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@SEGMENTID	int	IN
@SEPARATOR	nvarchar(20)	IN
@SEGMENTTYPE	nvarchar(50)	IN
@SEGMENTLENGTH	int	IN
@SEGMENTSEQUENCE	int	IN

Definition

Copy



            create procedure dbo.USP_FENXT_ADDACCOUNTSTRUCTURE
                (
                @PDACCOUNTSYSTEMID uniqueidentifier,
                @SEGMENTID int,
                @SEPARATOR nvarchar(20),
                @SEGMENTTYPE nvarchar(50),
                @SEGMENTLENGTH int,
                @SEGMENTSEQUENCE int
                )
                as

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

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

                insert into dbo.FENXTACCOUNTSTRUCTURE
                    (PDACCOUNTSYSTEMID,
                    SEGMENTID,
                    SEPARATOR,
                    SEGMENTTYPE,
                    SEGMENTLENGTH,
                    SEGMENTSEQUENCE,
                    ADDEDBYID,
                    CHANGEDBYID,
                    DATEADDED,
                    DATECHANGED)
                values 
                    (@PDACCOUNTSYSTEMID,
                    @SEGMENTID,
                    @SEPARATOR,
                    @SEGMENTTYPE,
                    @SEGMENTLENGTH,
                    @SEGMENTSEQUENCE,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE);