Gifts
Returns a paginated list of gifts
Table Specific Information
Select
The connector 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 connector.
- Id supports the '=' operator.
- ConstituentId supports the '=,in' operators.
- Date supports the '>=,<=' operators.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
- PostStatus supports the '=,in' operators.
- Type supports the '=' operator.
- ListId supports the '=' operator.
- AppealId supports the '=,in' operators.
- FundId supports the '=,in' operators.
- CampaignId supports the '=,in' operators.
- AcknowledgmentStatus supports the '=,in' operators.
- ReceiptStaus supports the '=,in' operators.
SELECT * FROM Gifts WHERE ConstituentId IN ('280', '281')
SELECT * FROM Gifts WHERE PostStatus = 'Posted'
SELECT * FROM Gifts WHERE Type IN ('Pledge', 'GiftInKind')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the gift. | |
| AmountValue | Double | The monetary amount of the gift. | |
| BalanceValue | Double | The balance remaining on the gift. | |
| BatchNumber | String | The batch number associated with this gift. | |
| Constituency | String | The constituency of the gift. | |
| ConstituentId | String | The immutable system record ID of the constituent associated with the gift. | |
| Date | Date | The gift date. | |
| DateAdded | Datetime | The date when the gift was created. | |
| DateModified | Datetime | The date when the gift was last modified. | |
| GiftAidAmountValue | Double | This computed field calculates the total qualified amount of tax reclaimed from Gift Aid across all gift_splits for this gift. | |
| GiftAidQualificationStatus | String | This computed field determines the Gift Aid qualification status based on tax declaration information and the database format. Available values are: Qualified, NotQualified, and PartlyQualified. For the UK only. | |
| GiftStatus | String | The status of the gift. Available values are Active, Held, Terminated, Completed, and Cancelled. | |
| IsAnonymous | Bool | Indicates whether the gift is anonymous. | |
| LinkedGifts | String | The identifiers of other gifts that are linked to this gift. | |
| LookupId | String | The user-defined identifier for the gift. | |
| Origin | String | The origin of the gift. | |
| PostDate | Datetime | The date that the gift was posted to general ledger. | |
| PostStatus | String | The general ledger post status of the gift. | |
| RecurringGiftStatusDateD | Integer | The date (D) that the gift status was last modified. | |
| RecurringGiftStatusDateM | Integer | The date (M) that the gift status was last modified. | |
| RecurringGiftStatusDateY | Integer | The date (Y) that the gift status was last modified. | |
| Reference | String | Notes to track special details about a gift such as the motivation behind it or a detailed description of a gift-in-kind. | |
| Subtype | String | The subtype of the gift. | |
| Type | String | The gift type. | |
| GiftCode | String | The gift Code. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ListId | String | Defines a list identifier used to filter the set of gifts to those included in the specified list. If this value is set, other specified filters will be ignored. | |
| AppealId | String | Returns gifts if any of the specified appeal identifiers match any of their appeals. | |
| FundId | String | Returns gifts if any of the specified fund identifiers match any of their funds. | |
| CampaignId | String | Returns gifts if any of the specified campaign identifiers match any of their campaigns. | |
| AcknowledgmentStatus | String | Returns gifts if their acknowledgement status matches any specified. | |
| ReceiptStaus | String | Returns gifts if their receipt status matches any specified. |