UFN_FINANCIALTRANSACTION_PAYMENTPOSTED
This returns a payment has been posted given the id of the originating financial transaction id (invoice, credit memo, etc).
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_FINANCIALTRANSACTION_PAYMENTPOSTED(
@ID uniqueidentifier
)
returns bit
with execute as caller
as begin
declare @POSTSTATUSCODE tinyint
declare @POSTED bit
select top 1 @POSTSTATUSCODE = FTLI2.POSTSTATUSCODE
from dbo.FINANCIALTRANSACTION FT
join dbo.FINANCIALTRANSACTIONSCHEDULE FTS on FT.ID = FTS.FINANCIALTRANSACTIONID
join dbo.FINANCIALTRANSACTIONAPPLICATION FTA on FTA.FINANCIALTRANSACTIONSCHEDULEID = FTS.ID
join dbo.FINANCIALTRANSACTION FT2 on FTA.FINANCIALTRANSACTIONID = FT2.ID
join dbo.FINANCIALTRANSACTIONLINEITEM FTLI2 on ((FT2.ID = FTLI2.FINANCIALTRANSACTIONID) and (FTLI2.TYPECODE = 0) and (FTLI2.DELETEDON is null))
where FTA.STATUSCODE <> 2 and FT.ID = @ID and FTLI2.POSTSTATUSCODE=2
if @POSTSTATUSCODE = 2
set @POSTED = 1
else
set @POSTED = 0
return @POSTED
end