USP_DATAFORMTEMPLATE_VIEW_MISCPAYMENTPAGEDATA

The load procedure used by the view dataform template "Miscellaneous Payment Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@REVENUEID	uniqueidentifier	INOUT	RevenueID
@AMOUNT	money	INOUT	Amount
@DATE	datetime	INOUT	Date
@CONSTITUENTNAME	nvarchar(255)	INOUT	Constituent
@ISGIFT	bit	INOUT	Is gift
@ISPLEDGE	bit	INOUT	Is pledge
@ISRECURRINGGIFT	bit	INOUT	Is recurring gift
@ISMGPLEDGE	bit	INOUT	Is matching gift claim
@ISPLANNEDGIFT	bit	INOUT	Is planned gift
@ISPAYMENT	bit	INOUT	Is payment
@ISPOSTED	bit	INOUT	Is posted
@LINKEDRECORDID	uniqueidentifier	INOUT	Linked record
@ALLOWEDITPAYMENT	bit	INOUT	Allow Edit Payment
@BENEFITSWAIVED	bit	INOUT	Benefits waived
@CANROLLBACK	bit	INOUT	Can rollback transaction
@CANSKIPTRANSACTION	bit	INOUT	Can skip transaction
@ISPENDING	bit	INOUT	Is pending
@EXTRADATAISPOSTED	bit	INOUT	Extra data is posted
@HASWRITEOFF	bit	INOUT	Has write-offs
@HASADJUSTMENTS	bit	INOUT	Has Adjustments
@HASUNPOSTEDREVERSAL	bit	INOUT	Has unposted GL Reversal
@HASUNPOSTEDADJUSTMENT	bit	INOUT	Has unposted Revenue Adjustment
@HASUNPOSTEDEXTRADATA	bit	INOUT	Has unposted Stock or Property Adjustment
@TYPE	nvarchar(26)	INOUT	Type
@PLEDGEBALANCE	money	INOUT	Pledge balance
@PAYMENTTYPECODE	tinyint	INOUT	Payment type code
@ATTRIBUTEDEFINED	bit	INOUT	Attribute defined
@REVENUECOUNT	int	INOUT	Revenue count
@ALLOWMATCHINGGIFTCLAIM	bit	INOUT	Allow matching gift claim
@HASTRIBUTES	bit	INOUT	Has tributes
@CANAPPLYTRIBUTE	bit	INOUT	Can apply tribute
@PAYMENTINCLUDESGIFT	bit	INOUT	Payment includes gift
@RECEIPTSTATUSCODE	tinyint	INOUT	Receipt status code
@MGPLEDGEISINACTIVE	bit	INOUT	Matching gift claim is inactive
@ISCONSTITUENTHOUSEHOLD	bit	INOUT	Is the transaction's associated constituent a household
@HOUSEHOLDSCANBEDONORS	bit	INOUT	Can households be donors
@NEEDSRERECEIPT	bit	INOUT	Needs re-receipt
@RECEIPTCOUNT	int	INOUT	Receipt count
@PLANNEDGIFTID	uniqueidentifier	INOUT	Planned gift ID
@REVENUEPAYMENTMETHODID	uniqueidentifier	INOUT	Revenue payment method ID
@DONOTPOST	bit	INOUT	Do not post
@SALEPOSTSTATUSCODE	tinyint	INOUT	Sale post status code
@HASSOLDSTOCK	bit	INOUT	Has sold stock
@GIFTFEE_ENABLED	bit	INOUT	GIFTFEE_ENABLED
@HASSOLDPROPERTY	bit	INOUT	Has sold property
@ELIGIBLEFORMATCHINGGIFTCLAIM	bit	INOUT	Eligible for matching gift claims
@ISORDER	bit	INOUT	Is order
@SALESORDERID	uniqueidentifier	INOUT	Sales order ID
@ISORDERAPPLICATION	bit	INOUT	Is order application
@HASGIFTAIDGLDISTRIBUTIONS	bit	INOUT	Has gift aid distributions
@SALESORDERPAYMENTID	uniqueidentifier	INOUT	Sales order payment ID
@ORDERTICKETTOTAL	money	INOUT	Order ticket total
@ORDERMEMBERSHIPTOTAL	money	INOUT	Order membership total
@ORDERDONATIONTOTAL	money	INOUT	Order discount total
@ORDERADJUSTMENTTOTAL	money	INOUT	Order adjustments total
@ORDERHASMEMBERSHIP	bit	INOUT	Order has memberships
@ORDERHASDONATION	bit	INOUT	Order has discounts
@ORDERHASADJUSTMENT	bit	INOUT	Order has adjustments
@ISMISCELLANEOUSPAYMENT	bit	INOUT	Is miscellaneous payment
@REFERENCE	nvarchar(255)	INOUT	Reference
@REFUNDSTATUS	tinyint	INOUT	Refund status
@REFUNDTOTAL	money	INOUT	Refund total
@ORDERHASEVENTREGISTRATION	bit	INOUT	ORDERHASEVENTREGISTRATION
@ORDEREVENTREGISTRATIONTOTAL	money	INOUT	ORDEREVENTREGISTRATIONTOTAL
@ISGRANTAWARD	bit	INOUT	Is grant award
@RGISOPEN	bit	INOUT	Recurring gift is open
@SPONSORSHIPID	uniqueidentifier	INOUT	SPONSORSHIPID
@SPONSORSHIPOPPORTUNITY	nvarchar(200)	INOUT	SPONSORSHIPOPPORTUNITY
@ORDERHASRESOURCE	bit	INOUT	ORDERHASRESOURCE
@ORDERRESOURCETOTAL	money	INOUT	ORDERRESOURCETOTAL
@ORDERHASSTAFFRESOURCE	bit	INOUT	ORDERHASSTAFFRESOURCE
@ORDERSTAFFRESOURCETOTAL	money	INOUT	ORDERSTAFFRESOURCETOTAL
@CONSTITUENTISGRANTOR	bit	INOUT	CONSTITUENTISGRANTOR
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@HASPLANNEDGIFTPAYOUT	bit	INOUT	HASPLANNEDGIFTPAYOUT
@RGHASDEVELOPMENTHISTORY	bit	INOUT	RGHASDEVELOPMENTHISTORY
@HASBENEFITDISTRIBUTION	bit	INOUT	HASBENEFITDISTRIBUTION
@HASGLDISTRIBUTIONS	bit	INOUT	HASGLDISTRIBUTIONS
@HASDNPADJUSTMENT	bit	INOUT	HASDNPADJUSTMENT
@ISMIXEDORDERPAYMENT	bit	INOUT	ISMIXEDORDERPAYMENT
@HASGIFTAIDSPLITONPENDINGR68PROCESS	bit	INOUT	HASGIFTAIDSPLITONPENDINGR68PROCESS
@HASPOSTEDBENEFITS	bit	INOUT	HASPOSTEDBENEFITS
@ISAUCTIONDONATION	bit	INOUT	ISAUCTIONDONATION
@PAYMENTALLOWSCREDITCARDREFUND	bit	INOUT	PAYMENTALLOWSCREDITCARDREFUND
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	TRANSACTIONCURRENCYID
@SHOWGLINFO	bit	INOUT	SHOWGLINFO
@AUCTIONITEMID	uniqueidentifier	INOUT	AUCTIONITEMID
@HASAUCTIONPURCHASE	bit	INOUT	HASAUCTIONPURCHASE
@ISDONORCHALLENGE	bit	INOUT	ISDONORCHALLENGE
@AUCTIONDONATIONISRESERVEDORSOLD	bit	INOUT	AUCTIONDONATIONISRESERVEDORSOLD
@HASGIFTFEEGLDISTRIBUTIONS	bit	INOUT	Has gift fees distributions
@HASPOSTEDGIFTFEES	bit	INOUT	HASPOSTEDGIFTFEES
@HASUNPOSTEDGIFTFEESADJUSTMENT	bit	INOUT	HASUNPOSTEDGIFTFEESADJUSTMENT
@SHOWREVENUEGLDISTRIBUTIONS	bit	INOUT	SHOWREVENUEGLDISTRIBUTIONS
@ORDERHASFACILITY	bit	INOUT	ORDERHASFACILITY
@ORDERFACILITYTOTAL	money	INOUT	ORDERFACILITYTOTAL
@ORDERHASMERCHANDISE	bit	INOUT	ORDERHASMERCHANDISE
@ORDERMERCHANDISETOTAL	money	INOUT	ORDERMERCHANDISETOTAL
@HASUNREALIZEDGAINLOSS	bit	INOUT	HASUNREALIZEDGAINLOSS
@HASSYSTEMDISTRIBUTIONS	bit	INOUT	HASSYSTEMDISTRIBUTIONS
@ISPLANNEDGIFTADDITION	bit	INOUT	ISPLANNEDGIFTADDITION
@PLANNEDGIFTADDITIONID	uniqueidentifier	INOUT	PLANNEDGIFTADDITIONID
@HASMATCHINGACCOUNTSYSTEM	bit	INOUT	HASMATCHINGACCOUNTSYSTEM
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT	PDACCOUNTSYSTEMID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MISCPAYMENTPAGEDATA
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CONSTITUENTID uniqueidentifier = null output,
    @REVENUEID uniqueidentifier = null output,
    @AMOUNT money = null output,
    @DATE datetime = null output,
    @CONSTITUENTNAME nvarchar(255) = null output,
    @ISGIFT bit = null output,
    @ISPLEDGE bit = null output,
    @ISRECURRINGGIFT bit = null output,
    @ISMGPLEDGE bit = null output,
    @ISPLANNEDGIFT bit = null output,
    @ISPAYMENT bit = null output,
    @ISPOSTED bit = null output,
    @LINKEDRECORDID uniqueidentifier = null output,
    @ALLOWEDITPAYMENT bit = null output,
    @BENEFITSWAIVED bit = null output,
    @CANROLLBACK bit = null output,
    @CANSKIPTRANSACTION bit = null output,                    
    @ISPENDING bit = null output,
    @EXTRADATAISPOSTED bit = null output,
    @HASWRITEOFF bit = null output,
    @HASADJUSTMENTS bit = null output,
    @HASUNPOSTEDREVERSAL bit = null output,
    @HASUNPOSTEDADJUSTMENT bit = null output,
    @HASUNPOSTEDEXTRADATA bit = null output,
    @TYPE nvarchar(26) = null output,
    @PLEDGEBALANCE money = null output,
    @PAYMENTTYPECODE tinyint = null output,
    @ATTRIBUTEDEFINED bit = null output,
    @REVENUECOUNT int = null output,
    @ALLOWMATCHINGGIFTCLAIM bit = null output,
    @HASTRIBUTES bit = null output,
    @CANAPPLYTRIBUTE bit = null output,
    @PAYMENTINCLUDESGIFT bit = null output,
    @RECEIPTSTATUSCODE tinyint = null output,
    @MGPLEDGEISINACTIVE bit = null output,
    @ISCONSTITUENTHOUSEHOLD bit = null output,
    @HOUSEHOLDSCANBEDONORS bit = null output,
    @NEEDSRERECEIPT bit = null output,
    @RECEIPTCOUNT int = null output,
    @PLANNEDGIFTID uniqueidentifier = null output,    
    @REVENUEPAYMENTMETHODID uniqueidentifier = null output,
    @DONOTPOST bit = null output,
    @SALEPOSTSTATUSCODE tinyint = null output,
    @HASSOLDSTOCK bit = null output,
    @GIFTFEE_ENABLED bit = null output,
    @HASSOLDPROPERTY bit = null output,
    @ELIGIBLEFORMATCHINGGIFTCLAIM bit = null output,
    @ISORDER bit = null output,
    @SALESORDERID uniqueidentifier = null output,
    @ISORDERAPPLICATION bit = null output,
    @HASGIFTAIDGLDISTRIBUTIONS bit = null output,
    @SALESORDERPAYMENTID uniqueidentifier = null output,
    @ORDERTICKETTOTAL money = null output,
    @ORDERMEMBERSHIPTOTAL money = null output,
    @ORDERDONATIONTOTAL money = null output,
    @ORDERADJUSTMENTTOTAL money = null output,
    @ORDERHASMEMBERSHIP bit = null output,
    @ORDERHASDONATION bit = null output,
    @ORDERHASADJUSTMENT bit = null output,
    @ISMISCELLANEOUSPAYMENT bit = null output,
    @REFERENCE nvarchar(255) = null output,
    @REFUNDSTATUS tinyint = null output,
    @REFUNDTOTAL money = null output,
    @ORDERHASEVENTREGISTRATION bit = null output,
    @ORDEREVENTREGISTRATIONTOTAL money = null output,
    @ISGRANTAWARD bit = null output,
    @RGISOPEN bit = null output,
    @SPONSORSHIPID uniqueidentifier = null output,
    @SPONSORSHIPOPPORTUNITY nvarchar(200) = null output,
    @ORDERHASRESOURCE bit = null output,
    @ORDERRESOURCETOTAL money = null output,
    @ORDERHASSTAFFRESOURCE bit = null output,
    @ORDERSTAFFRESOURCETOTAL money = null output,
    @CONSTITUENTISGRANTOR bit = null output,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @HASPLANNEDGIFTPAYOUT bit = null output,
    @RGHASDEVELOPMENTHISTORY bit = null output,
    @HASBENEFITDISTRIBUTION bit = null output,
    @HASGLDISTRIBUTIONS bit = null output,
    @HASDNPADJUSTMENT bit = null output,
    @ISMIXEDORDERPAYMENT bit = null output,
    @HASGIFTAIDSPLITONPENDINGR68PROCESS bit = null output,
    @HASPOSTEDBENEFITS bit = null output,
    @ISAUCTIONDONATION bit = null output,
    @PAYMENTALLOWSCREDITCARDREFUND bit = null output,
    @TRANSACTIONCURRENCYID uniqueidentifier = null output,
    @SHOWGLINFO bit = null output,
    @AUCTIONITEMID uniqueidentifier = null output,
    @HASAUCTIONPURCHASE bit = null output,
    @ISDONORCHALLENGE bit = null output,
    @AUCTIONDONATIONISRESERVEDORSOLD bit = null output,
    @HASGIFTFEEGLDISTRIBUTIONS bit = null output,
    @HASPOSTEDGIFTFEES bit = null output,
    @HASUNPOSTEDGIFTFEESADJUSTMENT bit = null output,
    @SHOWREVENUEGLDISTRIBUTIONS bit = null output,
    @ORDERHASFACILITY bit = null output,
    @ORDERFACILITYTOTAL money = null output,
    @ORDERHASMERCHANDISE bit = null output,
    @ORDERMERCHANDISETOTAL money = null output,
    @HASUNREALIZEDGAINLOSS bit = null output,
    @HASSYSTEMDISTRIBUTIONS bit = null output,
    @ISPLANNEDGIFTADDITION bit = null output,
    @PLANNEDGIFTADDITIONID uniqueidentifier = null output,
    @HASMATCHINGACCOUNTSYSTEM bit = null output,
    @PDACCOUNTSYSTEMID uniqueidentifier = null output)
    as
    set nocount on;

    set @DATALOADED = 0;

    exec dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUETRANSACTIONPAGEDATA
            @ID = @ID,
            @DATALOADED = @DATALOADED output,
            @CONSTITUENTID = @CONSTITUENTID output,
            @REVENUEID = @REVENUEID output,
            @AMOUNT = @AMOUNT output,
            @DATE = @DATE output,
            @CONSTITUENTNAME = @CONSTITUENTNAME output,
            @ISGIFT = @ISGIFT output,
            @ISPLEDGE = @ISPLEDGE output,
            @ISRECURRINGGIFT = @ISRECURRINGGIFT output,
            @ISMGPLEDGE = @ISMGPLEDGE output,
            @ISPLANNEDGIFT = @ISPLANNEDGIFT output,
            @ISPAYMENT = @ISPAYMENT output,
            @ISPOSTED = @ISPOSTED output,
            @LINKEDRECORDID = @LINKEDRECORDID output,
            @ALLOWEDITPAYMENT =@ALLOWEDITPAYMENT output,
            @BENEFITSWAIVED = @BENEFITSWAIVED output,
            @CANROLLBACK = @CANROLLBACK output,
            @CANSKIPTRANSACTION= @CANSKIPTRANSACTION output,                    
            @ISPENDING = @ISPENDING output,
            @EXTRADATAISPOSTED = @EXTRADATAISPOSTED output,
            @HASWRITEOFF = @HASWRITEOFF output,
            @HASADJUSTMENTS = @HASADJUSTMENTS output,
            @HASUNPOSTEDREVERSAL = @HASUNPOSTEDREVERSAL output,
            @HASUNPOSTEDADJUSTMENT = @HASUNPOSTEDADJUSTMENT output,
            @HASUNPOSTEDEXTRADATA = @HASUNPOSTEDEXTRADATA output,
            @TYPE = @TYPE output,
            @PLEDGEBALANCE = @PLEDGEBALANCE output,
            @PAYMENTTYPECODE = @PAYMENTTYPECODE output,
            @ATTRIBUTEDEFINED = @ATTRIBUTEDEFINED output,
            @REVENUECOUNT = @REVENUECOUNT output,
            @ALLOWMATCHINGGIFTCLAIM = @ALLOWMATCHINGGIFTCLAIM output,
            @HASTRIBUTES = @HASTRIBUTES output,
            @CANAPPLYTRIBUTE = @CANAPPLYTRIBUTE output,
            @PAYMENTINCLUDESGIFT = @PAYMENTINCLUDESGIFT output,
            @RECEIPTSTATUSCODE = @RECEIPTSTATUSCODE output,
            @MGPLEDGEISINACTIVE = @MGPLEDGEISINACTIVE output,
            @ISCONSTITUENTHOUSEHOLD = @ISCONSTITUENTHOUSEHOLD output,
            @HOUSEHOLDSCANBEDONORS = @HOUSEHOLDSCANBEDONORS output,
            @NEEDSRERECEIPT = @NEEDSRERECEIPT output,
            @RECEIPTCOUNT = @RECEIPTCOUNT output,
            @PLANNEDGIFTID = @PLANNEDGIFTID output,    
            @REVENUEPAYMENTMETHODID = @REVENUEPAYMENTMETHODID output,
            @DONOTPOST = @DONOTPOST output,
            @SALEPOSTSTATUSCODE = @SALEPOSTSTATUSCODE output,
            @HASSOLDSTOCK = @HASSOLDSTOCK output,
            @GIFTFEE_ENABLED = @GIFTFEE_ENABLED output,
            @HASSOLDPROPERTY = @HASSOLDPROPERTY output,
            @ELIGIBLEFORMATCHINGGIFTCLAIM = @ELIGIBLEFORMATCHINGGIFTCLAIM output,
            @ISORDER = @ISORDER output,
            @SALESORDERID = @SALESORDERID output,
            @ISORDERAPPLICATION = @ISORDERAPPLICATION output,
            @HASGIFTAIDGLDISTRIBUTIONS = @HASGIFTAIDGLDISTRIBUTIONS output,
            @SALESORDERPAYMENTID = @SALESORDERPAYMENTID output,
            @ORDERTICKETTOTAL = @ORDERTICKETTOTAL output,
            @ORDERMEMBERSHIPTOTAL = @ORDERMEMBERSHIPTOTAL output,
            @ORDERDONATIONTOTAL = @ORDERDONATIONTOTAL output,
            @ORDERADJUSTMENTTOTAL = @ORDERADJUSTMENTTOTAL output,
            @ORDERHASMEMBERSHIP = @ORDERHASMEMBERSHIP output,
            @ORDERHASDONATION = @ORDERHASDONATION output,
            @ORDERHASADJUSTMENT = @ORDERHASADJUSTMENT output,
            @ISMISCELLANEOUSPAYMENT = @ISMISCELLANEOUSPAYMENT output,
            @REFERENCE = @REFERENCE output,
            @REFUNDSTATUS = @REFUNDSTATUS output,
            @REFUNDTOTAL = @REFUNDTOTAL output,
            @ORDERHASEVENTREGISTRATION = @ORDERHASEVENTREGISTRATION output,
            @ORDEREVENTREGISTRATIONTOTAL = @ORDEREVENTREGISTRATIONTOTAL output,
            @ISGRANTAWARD = @ISGRANTAWARD output,
            @RGISOPEN = @RGISOPEN output,
            @SPONSORSHIPID = @SPONSORSHIPID output,
            @SPONSORSHIPOPPORTUNITY = @SPONSORSHIPOPPORTUNITY output,
            @ORDERHASRESOURCE = @ORDERHASRESOURCE output,
            @ORDERRESOURCETOTAL = @ORDERRESOURCETOTAL output,
            @ORDERHASSTAFFRESOURCE = @ORDERHASSTAFFRESOURCE output,
            @ORDERSTAFFRESOURCETOTAL = @ORDERSTAFFRESOURCETOTAL output,
            @CONSTITUENTISGRANTOR = @CONSTITUENTISGRANTOR output,
            @CURRENTAPPUSERID = @CURRENTAPPUSERID,
            @HASPLANNEDGIFTPAYOUT = @HASPLANNEDGIFTPAYOUT output,
            @RGHASDEVELOPMENTHISTORY = @RGHASDEVELOPMENTHISTORY output,
            @HASBENEFITDISTRIBUTION = @HASBENEFITDISTRIBUTION output,
            @HASGLDISTRIBUTIONS = @HASGLDISTRIBUTIONS output,
            @HASDNPADJUSTMENT = @HASDNPADJUSTMENT output,
            @ISMIXEDORDERPAYMENT = @ISMIXEDORDERPAYMENT output,
            @HASGIFTAIDSPLITONPENDINGR68PROCESS = @HASGIFTAIDSPLITONPENDINGR68PROCESS output,
            @HASPOSTEDBENEFITS = @HASPOSTEDBENEFITS output,
            @ISAUCTIONDONATION = @ISAUCTIONDONATION output,
            @PAYMENTALLOWSCREDITCARDREFUND = @PAYMENTALLOWSCREDITCARDREFUND output,
            @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
            @SHOWGLINFO = @SHOWGLINFO output,
            @AUCTIONITEMID = @AUCTIONITEMID output,
            @HASAUCTIONPURCHASE = @HASAUCTIONPURCHASE output,
            @ISDONORCHALLENGE = @ISDONORCHALLENGE output,
            @AUCTIONDONATIONISRESERVEDORSOLD = @AUCTIONDONATIONISRESERVEDORSOLD output,
            @HASGIFTFEEGLDISTRIBUTIONS = @HASGIFTFEEGLDISTRIBUTIONS output,
            @HASPOSTEDGIFTFEES = @HASPOSTEDGIFTFEES output,
            @HASUNPOSTEDGIFTFEESADJUSTMENT = @HASUNPOSTEDGIFTFEESADJUSTMENT output,
            @SHOWREVENUEGLDISTRIBUTIONS = @SHOWREVENUEGLDISTRIBUTIONS output,
            @ORDERHASFACILITY = @ORDERHASFACILITY output,
            @ORDERFACILITYTOTAL = @ORDERFACILITYTOTAL output,
            @ORDERHASMERCHANDISE = @ORDERHASMERCHANDISE output,
            @ORDERMERCHANDISETOTAL = @ORDERMERCHANDISETOTAL output,
            @HASUNREALIZEDGAINLOSS = @HASUNREALIZEDGAINLOSS output,
            @HASSYSTEMDISTRIBUTIONS = @HASSYSTEMDISTRIBUTIONS output,
            @ISPLANNEDGIFTADDITION = @ISPLANNEDGIFTADDITION output,
            @PLANNEDGIFTADDITIONID = @PLANNEDGIFTADDITIONID output,
            @HASMATCHINGACCOUNTSYSTEM = @HASMATCHINGACCOUNTSYSTEM output,
            @PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID output

    return 0;