USP_VIEWFORM_VIEWBYDISBURSEMENTDETAIL
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @PROCESSORTRANSACTIONSETTLEMENTIMPORTID | uniqueidentifier | INOUT | |
| @VENDORID | nvarchar(50) | INOUT | |
| @DATETYPE | tinyint | INOUT | |
| @FILTERDATE | datetime | INOUT |
Definition
Copy
CREATE procedure dbo.USP_VIEWFORM_VIEWBYDISBURSEMENTDETAIL (
@ID uniqueidentifier
,@DATALOADED bit = 0 output
,@PROCESSORTRANSACTIONSETTLEMENTIMPORTID uniqueidentifier = null output
,@VENDORID nvarchar(50) = null output
,@DATETYPE tinyint = null output
,@FILTERDATE datetime = null output
)
as
begin
set nocount on;
set @PROCESSORTRANSACTIONSETTLEMENTIMPORTID = @ID;
set @VENDORID = '';
set @DATETYPE = 0;
set @DATALOADED = 1;
return 0
end