Power BI Connector for Blackbaud Raisers Edge NXT

Build 24.0.9062

GiftSplits

Returns the splits for a gift.

Table Specific Information

Select

The 本製品 will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • GiftId supports the '=' operator.
For example:
	SELECT * FROM GiftSplits
	SELECT * FROM GiftSplits WHERE GiftId = '476'

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the gift split.
GiftId String

Gifts.Id

The immutable system record ID of the gift associated with the gift split.
AmountValue Decimal The amount of the gift split.
AppealId String The immutable system record ID of the appeal associated with the gift split.
CampaignId String The immutable system record ID of the campaign associated with the gift split.
FundId String The immutable system record ID of the fund associated with the gift split.
GiftAidAmount Decimal The amount of tax reclaimed from gift aid for this gift split. For the UK only.
GiftAidQualificationStatus String The gift aid qualification status of the gift split. Available values are: Qualified, and NotQualified. For the UK only.
PackageId String The immutable system record ID of the package associated with the gift split.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062