USP_DATAFORMTEMPLATE_ADD_FENXTIMPORTACCOUNT

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FENXTIMPORTACCOUNT
                    (
                        @ID uniqueidentifier = null output,
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @FIELDNOTUSED varchar(20) = null --loadspec has an issue if this is not present

                    )
                    as

                    set nocount on;

                    if @ID is null
                        set @ID = newid();

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

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

                    begin try
                        insert into dbo.GLACCOUNT
                                        (
                                        ACCOUNTNUMBER,
                                        ACCOUNTDESCRIPTION,
                                        ADDEDBYID,
                                        CHANGEDBYID,
                                        DATEADDED,
                                        DATECHANGED, 
                                        PDACCOUNTSYSTEMID,
                                        ACTIVE)
                        select 
                            ACCOUNTNUMBER,
                            DESCRIPTION,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE,
                            @PDACCOUNTSYSTEMID,
                            1
                        from dbo.FENXTACCOUNT
                        where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
                        and PROJECTREQUIRED = 1
                        and not exists (select 1 from dbo.GLACCOUNT where GLACCOUNT.ACCOUNTNUMBER = FENXTACCOUNT.ACCOUNTNUMBER and GLACCOUNT.PDACCOUNTSYSTEMID = FENXTACCOUNT.PDACCOUNTSYSTEMID);
                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;