GLPAYMENTMETHODREVENUETYPEMAPPING
Stores mapping of Payment Methods and/or Revenue Type to Account Types (defined in GLAccountTypeMapping)
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| PAYMENTMETHODCODE |
tinyint |
|
Default = 0 |
The method of payment in which the revenue was received. |
| DESCRIPTION |
nvarchar(100) |
|
Default = '' |
|
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| REVENUETRANSACTIONTYPECODE |
tinyint |
|
Default = 0 |
The transaction type of the revenue. |
| REVENUESPLITTYPECODE |
tinyint |
|
Default = 0 |
The type of revenue split. |
| APPLICATIONCODE |
tinyint |
|
Default = 0 |
What the revenue is applied to. |
| TRANSACTIONTYPECODE |
tinyint |
|
Default = 0 |
The transaction type (debit or credit) for the record |
| TRANSACTIONTYPE |
nvarchar(6) (Computed) |
yes |
CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Debit' WHEN 1 THEN N'Credit' END |
Provides a translation for the 'TRANSACTIONTYPECODE' field. |
| REVENUESPLITTYPE |
nvarchar(31) (Computed) |
yes |
CASE [REVENUESPLITTYPECODE] WHEN 0 THEN N'Gift' WHEN 1 THEN N'Event registration' WHEN 2 THEN N'Membership' WHEN 3 THEN N'Grant award' WHEN 4 THEN N'Other' WHEN 5 THEN N'Ticket' WHEN 6 THEN N'Fee' WHEN 7 THEN N'Tax' WHEN 8 THEN N'Miscellaneous' WHEN 9 THEN N'Sponsorship' WHEN 10 THEN N'Supply/Equipment resource' WHEN 11 THEN N'Staffing resource' WHEN 12 THEN N'Auction purchase' WHEN 13 THEN N'Security deposit' WHEN 14 THEN N'Facility' WHEN 15 THEN N'Event sponsorship' WHEN 16 THEN N'Merchandise' WHEN 17 THEN N'Sponsorship additional gift' WHEN 18 THEN N'Membership add-on' WHEN 19 THEN N'Liability' WHEN 20 THEN N'Overage' WHEN 200 THEN N'All' WHEN 201 THEN N'Pledge payment for non-bookable' WHEN 202 THEN N'Gift Aid' WHEN 203 THEN N'Auction purchase gain' WHEN 204 THEN N'Auction purchase loss' END |
|
| REVENUETRANSACTIONTYPE |
nvarchar(31) (Computed) |
yes |
CASE [REVENUETRANSACTIONTYPECODE] WHEN 0 THEN N'Payment' WHEN 1 THEN N'Pledge' WHEN 2 THEN N'Recurring gift' WHEN 3 THEN N'Matching gift claim' WHEN 4 THEN N'Planned gift' WHEN 5 THEN N'Order' WHEN 6 THEN N'Grant award' WHEN 7 THEN N'Auction donation' WHEN 15 THEN N'Membership installment plan' WHEN 200 THEN N'All' WHEN 201 THEN N'Pledge payment for non-bookable' WHEN 202 THEN N'Gift Aid' WHEN 203 THEN N'Gift fee' END |
|
| APPLICATION |
nvarchar(36) (Computed) |
yes |
CASE [APPLICATIONCODE] WHEN 0 THEN N'Donation' WHEN 1 THEN N'Event registration' WHEN 2 THEN N'Pledge' WHEN 3 THEN N'Recurring gift' WHEN 4 THEN N'Other' WHEN 5 THEN N'Membership' WHEN 6 THEN N'Planned gift' WHEN 7 THEN N'Matching gift' WHEN 8 THEN N'Grant award' WHEN 9 THEN N'Ticket' WHEN 10 THEN N'Order' WHEN 11 THEN N'Miscellaneous' WHEN 12 THEN N'Auction purchase' WHEN 13 THEN N'Donor challenge' WHEN 15 THEN N'Event sponsorship' WHEN 16 THEN N'Merchandise' WHEN 17 THEN N'Pending gift' WHEN 18 THEN N'Membership add-on' WHEN 19 THEN N'Membership installment plan' WHEN 200 THEN N'All' WHEN 201 THEN N'Pledge payment for non-bookable' WHEN 202 THEN N'Gift Aid' WHEN 203 THEN N'Bookable membership installment plan' END |
|
| PAYMENTMETHOD |
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 |
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| GLACCOUNTTYPEMAPPINGID |
uniqueidentifier |
yes |
GLACCOUNTTYPEMAPPING.ID
|
FK to GLAccountTypeMapping table. Defines the account associated with the Payment Method/Revenue type combination |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_GLPAYMENTMETHODREVENUETYPEMAPPING_DATEADDED |
DATEADDED |
|
|
yes |
| IX_GLPAYMENTMETHODREVENUETYPEMAPPING_DATECHANGED |
DATECHANGED |
|
|
|
| PK_GLPAYMENTMETHODREVENUETYPEMAPPING |
ID |
yes |
yes |
|
Triggers
Referenced by