Funds

Returns the details of the specified fund.

The connector will use the Blackbaud Financial Edge NXT API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.

FundId supports the '=' operator. This column is required to query Funds.

For example, the following query is processed server side:

SELECT * FROM Funds WHERE FundId = 1

Columns


Name	Type	References	Description
FundId [KEY]	Integer		The fund identifier.
UiFundId	String		The fund user-visible identifier.
Description	String		The fund description.
InterfundType	String		The interfund type for this fund.
Class	String		The class for this fund.
Annotation	String		The annotation for this fund.
BeginningBalanceLocked	Boolean		Whether the beginning balance is locked for this fund.
BeginningBalanceLockedDate	Datetime		The date from which the beginning balance is locked.
InterfundDebitAccountId	Integer		The identifier of the interfund debit account.
InterfundDebitAccountAccount	String		The account number of the interfund debit account.
InterfundDebitAccountDescription	String		The description of the interfund debit account.
InterfundDebitAccountStatus	String		The status of the interfund debit account.
InterfundCreditAccountId	Integer		The identifier of the interfund credit account.
InterfundCreditAccountAccount	String		The account number of the interfund credit account.
InterfundCreditAccountDescription	String		The description of the interfund credit account.
InterfundCreditAccountStatus	String		The status of the interfund credit account.
InterfundSingleAccountId	Integer		The identifier of the interfund single account.
InterfundSingleAccountAccount	String		The account number of the interfund single account.
InterfundSingleAccountDescription	String		The description of the interfund single account.
InterfundSingleAccountStatus	String		The status of the interfund single account.
FundBalanceAccountId	Integer		The identifier of the fund balance account.
FundBalanceAccountAccount	String		The account number of the fund balance account.
FundBalanceAccountDescription	String		The description of the fund balance account.
FundBalanceAccountStatus	String		The status of the fund balance account.
FundRequirements	String		The transaction code requirements for this fund.
DateAdded	Datetime		The created date of the fund.
AddedBy	String		The creator of the fund.
DateModified	Datetime		The modified date of the fund.
ModifiedBy	String		The modifier of the fund.

Tableau Connector for Blackbaud Financial Edge NXT

Funds

Columns