USP_REVENUESPLIT_EXT_APPLICATIONCODE_GETLIST
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:11:27 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_REVENUESPLIT_EXT_APPLICATIONCODE_GETLIST
AS
select 0 'ID', 'Donation' 'DESCRIPTION'
union
select 1 'ID', 'Event registration' 'DESCRIPTION'
union
select 2 'ID', 'Pledge' 'DESCRIPTION'
union
select 3 'ID', 'Recurring gift' 'DESCRIPTION'
union
select 4 'ID', 'Other' 'DESCRIPTION'
union
select 5 'ID', 'Membership' 'DESCRIPTION'
union
select 6 'ID', 'Planned gift' 'DESCRIPTION'
union
select 7 'ID', 'Matching gift' 'DESCRIPTION'
union
select 8 'ID', 'Grant award' 'DESCRIPTION'
union
select 9 'ID', 'Admission' 'DESCRIPTION'
union
select 10 'ID', 'Order' 'DESCRIPTION'
union
select 11 'ID', 'Miscellaneous' 'DESCRIPTION'
union
select 12 'ID', 'Auction purchase' 'DESCRIPTION'
union
select 13 'ID', 'Donor challenge' 'DESCRIPTION'
union
select 15 'ID', 'Event sponsorship' 'DESCRIPTION'
union
select 16 'ID', 'Merchandise' 'DESCRIPTION'
union
select 17 'ID', 'Pending gift' 'DESCRIPTION'
union
select 18 'ID', 'Membership add-on' 'DESCRIPTION'
union
select 19 'ID', 'Membership installment plan' 'DESCRIPTION'