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