UFN_RECONCILIATION_STATUSCODE_GETDESCRIPTION_FORREFUND
Return the status of the refund based on the reconciliation status
Return
| Return Type |
|---|
| nvarchar(10) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_RECONCILIATION_STATUSCODE_GETDESCRIPTION_FORREFUND(@ID as uniqueidentifier)
returns nvarchar(10)
with execute as caller
as begin
return (isnull(
(select top 1 case when RECONCILIATION.STATUSCODE < 3 then RECONCILIATION.STATUS else 'Reconciled' end
from dbo.[CREDITPAYMENT]
inner join dbo.[RECONCILIATION]
on [CREDITPAYMENT].[RECONCILIATIONID] = [RECONCILIATION].[ID]
where [CREDITPAYMENT].[CREDITID] = @ID)
, dbo.UFN_RECONCILIATION_STATUSCODE_GETDESCRIPTION(0)));
end