Once the summarization process is complete, this is how you get data returned.
The driver 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 driver.
- FiscalYear, FiscalPeriod, AccountNumber and UiProjectId support the '=' operator. A blank search is not supported.
SELECT * FROM PeriodSummaries WHERE FiscalYear = 'year' AND FiscalPeriod = 'period' AND AccountNumber = 'abc' AND UiProjectId = 'def'You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.
|The summarized fiscal year.|
|The summarized fiscal period.|
|The account number of summarized transactions.|
|UiProjectId||String||The project identifier of summarized transactions.|
|PeriodStartDate||Datetime||The start date of the summarized period.|
|PeriodEndDate||Datetime||The end date of the summarized period.|
|TransactionCodes||String||The transaction code values of summarized transactions.|
|BeginningBalance||Double||The total transaction balance at the beginning of the summarized period.|
|Debit||Double||The sum of transaction debits int he summarized period.|
|Credit||Double||The sum of transaction credits int he summarized period.|
|EncumberedBeginningBalance||Double||The encumbered transaction balance at the beginning of the summarized period.|
|EncumberedCredit||Double||The sum of encumbered transaction credits int he summarized period.|
|EncumberedDebit||Double||The sum of encumbered transaction debits int he summarized period.|