UFN_AMPROIMPORT_REGISTRANTBALANCE

Returns the balance for a registrant referenced in an AuctionMaestro Pro import batch.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@REGISTRANTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_AMPROIMPORT_REGISTRANTBALANCE
            (
                @REGISTRANTID uniqueidentifier
            )
            returns money
            as
            begin
                declare @R money = null;

                if exists(select ID from dbo.BATCHAMPROIMPORTREGISTRANT where ID = @REGISTRANTID) 
                begin
                    select top 1 @R = REGISTRANT_AMOUNT from dbo.BATCHAMPROIMPORTREGISTRANT where ID = @REGISTRANTID;
                end
                else
                begin
                    select @R = dbo.UFN_EVENTREGISTRANT_GETBALANCE(@REGISTRANTID);
                end

                return @R;
            end