USP_STANDINGORDERSIMPORTPROCESS_GETPARAMETERS
Retrieves parameter settings for the standing orders import process.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_STANDINGORDERSIMPORTPROCESS_GETPARAMETERS
(
@ID uniqueidentifier = null
)
as
set nocount on;
select
[PROCESS].ID,
[PROCESS].NAME,
[PROCESS].BATCHTEMPLATEID,
[PROCESS].BATCHNUMBER,
[PROCESS].IMPORTFILENAME,
[PROCESS].IMPORTTEMPLATEID,
[IMPORTTEMPLATE].NAME [IMPORTTEMPLATENAME],
[PROCESS].DUEDATETYPECODE,
[PROCESS].CUTOFFDATE,
[PROCESS].DAYSAFTER,
[PROCESS].PAYFUTURE,
[PROCESS].OWNERID
from
dbo.STANDINGORDERSIMPORTPROCESS [PROCESS]
left join dbo.STANDINGORDERSIMPORTTEMPLATE [IMPORTTEMPLATE]
on [PROCESS].IMPORTTEMPLATEID = [IMPORTTEMPLATE].ID
where
[PROCESS].ID = @ID;