ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

GiftBatches

Returns a list of gift batches.

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 本製品.

  • BatchNumber supports the '=' operator.
  • CreatedBy supports the '=' operator.
  • HasExceptions supports the '=' operator.
  • IsApproved supports the '=' operator.
  • SearchText supports the '=' operator.

Columns

Name Type References Description
Id [KEY] String The batch identifier.
ActualAmount Double The actual batch amount.
BatchDescription String The batch description.
BatchNumber String The batch number.
CreatedBy String Created by user name.
AddedBy String Added by user name.
CreatedOn Datetime The date the batch was created.
DateAdded Datetime The date the batch was added.
HasExceptions Boolean The has exceptions boolean.
IsApproved Boolean Approved boolean.
Approved Boolean Approved boolean.
NumberOfGifts Integer The number of gifts in the batch.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
SearchText String If set to true, includes inactive gift batches in the result.

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