Accounts

Retrieve and query accounts.

The component 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 component.

Id supports the '=' operator. This column is filtered serverside when it is the only specified filter in the criteria.
DateModified supports the following operators : >,>=.

For example, the following queries are processed server side:

SELECT * FROM Accounts WHERE AccountId = 123
SELECT * FROM Accounts WHERE DateModified >= '2010-01-01 10:10:10'
SELECT * FROM Accounts WHERE DateModified > '2010-01-01 10:10:10'

Columns


Name	Type	References	Description
AccountId [KEY]	Integer		The identifier for this account.
AccountNumber	String		The account number for this account.
Class	String		The class for this account.
Description	String		The description for this account.
DateModified	Datetime		The modified date of the account.
WorkingCapital	String		The working capital schedule for this account.
Cashflow	String		The cash flow for this account.
PreventPostingDate	Datetime		If, and the date after which, to prevent posting. Filling out this field will automatically set the prevent data entry field to 'true'.
ModifiedBy	String		The modifier of the account.
DefaultTransactionCodes	String		The default transaction codes on this account.
PreventDataEntry	Boolean		If to prevent data entry. If a date is given for prevent posting, this value is set to true.
DateAdded	Datetime		The created date of the account.
AddedBy	String		The creator of the account.
CustomFields	String		Custom field : The list of custom fields supported as distict columns.

SSIS Components for Blackbaud Financial Edge NXT

Accounts

Columns