Returns a list of transactions for 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.

For example:

	SELECT * FROM MembershipTransactions WHERE MemberJunctionId = '1'

The rest of the filter is executed client-side within the driver.

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the membership transaction.
MemberJunctionId	String	Memberships.Id	The ID of the member junction record used to retrieve the membership transactions.
ActivityDate	Date		The date of the membership transaction.
CategoryName	String		The membership category name.
GiftsAggregate	String		The gifts applied to the membership transaction, aggregated as a JSON array of gift IDs and applied amounts.
MembershipComment	String		The comment on the membership transaction.
ProgramName	String		The membership program name.
Reason	String		The reason for the membership transaction.
SubcategoryName	String		The membership subcategory name.
Type	String		The type of the membership transaction. Available values include Joined and Dropped.