UFN_BATCHREVENUE_LOCKBOXINFOEXISTS
Check the lockbox, lockbox batch number and lockbox batch sequence combination already exist in the batch
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @LOCKBOXID | uniqueidentifier | IN | |
| @LOCKBOXBATCHNUMBER | nvarchar(100) | IN | |
| @LOCKBOXBATCHSEQUENCE | int | IN |
Definition
Copy
create function dbo.UFN_BATCHREVENUE_LOCKBOXINFOEXISTS(@ID uniqueidentifier, @LOCKBOXID uniqueidentifier = null, @LOCKBOXBATCHNUMBER nvarchar(100) = '', @LOCKBOXBATCHSEQUENCE int =0)
returns bit
as
begin
declare @BATCHID uniqueidentifier
declare @SEQUENCE int
if not @LOCKBOXID is null and LEN(@LOCKBOXBATCHNUMBER)>0
begin
select @SEQUENCE =SEQUENCE , @BATCHID=BATCHID from dbo.BATCHREVENUE where ID=@ID
if exists(select * from dbo.BATCHREVENUE where BATCHID=@BATCHID and SEQUENCE<@SEQUENCE and LOCKBOXID=@LOCKBOXID and LOCKBOXBATCHNUMBER=@LOCKBOXBATCHNUMBER and LOCKBOXBATCHSEQUENCE=@LOCKBOXBATCHSEQUENCE)
return 1;
else
return 0;
end
return 0;
end