JournalEntryBatches
Returns the list of journal entry batches.
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.
- BatchId supports the '=' operator. This column is filtered serverside when it is the only specified filter in the criteria.
SELECT * FROM JournalEntryBatches WHERE BatchId = 123
Columns
| Name | Type | References | Description |
| BatchId [KEY] | Integer | The batch identifier. | |
| UiBatchId | String | The batch user-visible identifier. | |
| Description | String | The batch description. | |
| BatchStatus | String | The batch status. | |
| CreateInterfundSets | Boolean | Indicates if or not the batch should create interfund entries when posted. | |
| CreateBankAccountAdjustments | Boolean | Indicates if or not the batch should create bank account admustments when posted. | |
| DateAdded | Datetime | The created date of the batch. | |
| AddedBy | String | The creator of the batch. | |
| DateModified | Datetime | The modified date of the batch. | |
| ModifiedBy | String | The modifier of the batch. |