USP_JOURNALENTRY_EXT_PAYMENTMETHODCODE_GETLIST
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 5/3/2024 2:16:45 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3700.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_JOURNALENTRY_EXT_PAYMENTMETHODCODE_GETLIST
AS
select 0 'ID', 'Cash' 'DESCRIPTION'
union
select 1 'ID', 'Check' 'DESCRIPTION'
union
select 2 'ID', 'Credit card' 'DESCRIPTION'
union
select 3 'ID', 'Direct debit' 'DESCRIPTION'
union
select 4 'ID', 'Stock' 'DESCRIPTION'
union
select 5 'ID', 'Property' 'DESCRIPTION'
union
select 6 'ID', 'Gift-in-kind' 'DESCRIPTION'
union
select 7 'ID', 'Sold stock' 'DESCRIPTION'
union
select 8 'ID', 'Sold property' 'DESCRIPTION'
union
select 9 'ID', 'None' 'DESCRIPTION'
union
select 10 'ID', 'Other' 'DESCRIPTION'
union
select 11 'ID', 'Standing order' 'DESCRIPTION'
union
select 12 'ID', 'Sold gift-in-kind' 'DESCRIPTION'
union
select 101 'ID', 'PayPal' 'DESCRIPTION'
union
select 102 'ID', 'Venmo' 'DESCRIPTION'
union
select 200 'ID', 'Sold stock gain' 'DESCRIPTION'
union
select 201 'ID', 'Sold property gain' 'DESCRIPTION'
union
select 202 'ID', 'Sold stock loss' 'DESCRIPTION'
union
select 203 'ID', 'Sold property loss' 'DESCRIPTION'
union
select 204 'ID', 'Fees' 'DESCRIPTION'
union
select 205 'ID', 'Write off' 'DESCRIPTION'
union
select 206 'ID', 'All' 'DESCRIPTION'
union
select 207 'ID', 'Sold gift-in-kind revenue addition' 'DESCRIPTION'
union
select 208 'ID', 'Sold gift-in-kind revenue reduction' 'DESCRIPTION'