GLPAYMENTMETHODREVENUETYPEMAPPING

Stores mapping of Payment Methods and/or Revenue Type to Account Types (defined in GLAccountTypeMapping)

For the full definition of the GLPAYMENTMETHODREVENUETYPEMAPPING table, see GLPAYMENTMETHODREVENUETYPEMAPPING.

Fields

Field	Change	Field Type	Null	Notes	Description
PAYMENTMETHOD	Changed	nvarchar(22) (Computed)	yes	CASE [PAYMENTMETHODCODE] WHEN 0 THEN N'Cash' WHEN 1 THEN N'Check' WHEN 2 THEN N'Credit card' WHEN 3 THEN N'Direct debit' WHEN 4 THEN N'Stock' WHEN 5 THEN N'Property' WHEN 6 THEN N'Gift-in-kind' WHEN 7 THEN N'Sold stock' WHEN 8 THEN N'Sold property' WHEN 9 THEN N'None' WHEN 10 THEN N'Other' WHEN 11 THEN N'Standing order' WHEN 12 THEN N'Sold gift-in-kind' WHEN 101 THEN N'PayPal' WHEN 102 THEN N'Venmo' WHEN 200 THEN N'Sold stock gain' WHEN 201 THEN N'Sold property gain' WHEN 202 THEN N'Sold stock loss' WHEN 203 THEN N'Sold property loss' WHEN 204 THEN N'Fees' WHEN 205 THEN N'Write off' WHEN 206 THEN N'All' WHEN 207 THEN N'Sold gift-in-kind gain' WHEN 208 THEN N'Sold gift-in-kind loss' END	Expression changed from CASE [PAYMENTMETHODCODE] WHEN 0 THEN N'Cash' WHEN 1 THEN N'Check' WHEN 2 THEN N'Credit card' WHEN 3 THEN N'Direct debit' WHEN 4 THEN N'Stock' WHEN 5 THEN N'Property' WHEN 6 THEN N'Gift-in-kind' WHEN 7 THEN N'Sold stock' WHEN 8 THEN N'Sold property' WHEN 9 THEN N'None' WHEN 10 THEN N'Other' WHEN 11 THEN N'Standing order' WHEN 12 THEN N'Sold gift-in-kind' WHEN 200 THEN N'Sold stock gain' WHEN 201 THEN N'Sold property gain' WHEN 202 THEN N'Sold stock loss' WHEN 203 THEN N'Sold property loss' WHEN 204 THEN N'Fees' WHEN 205 THEN N'Write off' WHEN 206 THEN N'All' WHEN 207 THEN N'Sold gift-in-kind gain' WHEN 208 THEN N'Sold gift-in-kind loss' END to CASE [PAYMENTMETHODCODE] WHEN 0 THEN N'Cash' WHEN 1 THEN N'Check' WHEN 2 THEN N'Credit card' WHEN 3 THEN N'Direct debit' WHEN 4 THEN N'Stock' WHEN 5 THEN N'Property' WHEN 6 THEN N'Gift-in-kind' WHEN 7 THEN N'Sold stock' WHEN 8 THEN N'Sold property' WHEN 9 THEN N'None' WHEN 10 THEN N'Other' WHEN 11 THEN N'Standing order' WHEN 12 THEN N'Sold gift-in-kind' WHEN 101 THEN N'PayPal' WHEN 102 THEN N'Venmo' WHEN 200 THEN N'Sold stock gain' WHEN 201 THEN N'Sold property gain' WHEN 202 THEN N'Sold stock loss' WHEN 203 THEN N'Sold property loss' WHEN 204 THEN N'Fees' WHEN 205 THEN N'Write off' WHEN 206 THEN N'All' WHEN 207 THEN N'Sold gift-in-kind gain' WHEN 208 THEN N'Sold gift-in-kind loss' END