USP_FENXT_SYNCBP

Parameters

Parameter Parameter Type Mode Description
@PARAMETERSETID uniqueidentifier IN

Definition

Copy


            CREATE procedure dbo.USP_FENXT_SYNCBP
                (
                @PARAMETERSETID as uniqueidentifier
                )
                as
                begin
                    select
                        PDACCOUNTSYSTEMID,
                        SYNCFISCALYEARS,
                        SYNCPROJECT_DESIGNATION,
                        SYNCACCOUNTS,
                        PURPOSETYPEID
                    from dbo.FENXTSYNCPROCESS
                    inner join dbo.FENXTINTEGRATION on FENXTSYNCPROCESS.FENXTINTEGRATIONID = FENXTINTEGRATION.ID
                    where FENXTSYNCPROCESS.ID = @PARAMETERSETID;
                end