UFN_BANKACCOUNTDISBURSEMENT_ISPURGED
Returns true if a bank disbursement has been purged
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_BANKACCOUNTDISBURSEMENT_ISPURGED(@ID as uniqueidentifier)
returns bit
as begin
declare @PURGED bit;
select @PURGED = CASE WHEN FT.DELETEDON IS NULL THEN 0 ELSE 1 END
from FINANCIALTRANSACTION FT
where FT.ID = @ID;
return @PURGED
end