MembershipLinkedGifts
Returns a list of gifts linked to a membership.
View-Specific Information
Select
The driver uses the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator.
- MemberJunctionId supports the = operator.
SELECT * FROM MembershipLinkedGifts WHERE MemberJunctionId = '1'
The rest of the filter is executed client-side within the driver.
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The immutable system record ID of the transaction gift link between the gift and the membership. | |
| MemberJunctionId | String |
Memberships.Id | The ID of the member junction record used to retrieve the linked gifts. |
| AppliedAmount | Decimal | The amount applied from the gift to the membership. | |
| ConstituentName | String | The name of the constituent associated with the linked gift. | |
| GiftDate | Date | The date of the linked gift. | |
| GiftId | String |
Gifts.Id | The immutable system record ID of the gift linked to the membership. |
| GiftType | String | The type of the linked gift. |