UFN_AMPROIMPORT_FINDUNPAIDREGISTRANT
Finds an unpaid registrant record for a constituent for AuctionMaestro Pro imports.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTAUCTIONID | uniqueidentifier | IN | |
| @CONSTITUENTID | uniqueidentifier | IN | |
| @AMOUNT | money | IN |
Definition
Copy
create function dbo.UFN_AMPROIMPORT_FINDUNPAIDREGISTRANT
(
@EVENTAUCTIONID uniqueidentifier,
@CONSTITUENTID uniqueidentifier,
@AMOUNT money
)
returns uniqueidentifier
as
begin
return
(
select top 1 REGISTRANT.ID
from dbo.REGISTRANT
left join dbo.REGISTRANTREGISTRATION on REGISTRANTREGISTRATION.REGISTRANTID = REGISTRANT.ID
left join dbo.EVENTREGISTRANTPAYMENT on EVENTREGISTRANTPAYMENT.REGISTRANTID = REGISTRANT.ID
where REGISTRANT.CONSTITUENTID = @CONSTITUENTID and REGISTRANT.EVENTID = @EVENTAUCTIONID
and EVENTREGISTRANTPAYMENT.ID is null
and (REGISTRANTREGISTRATION.AMOUNT = @AMOUNT or (@AMOUNT = 0 and REGISTRANTREGISTRATION.ID is null))
)
end