JournalEntries
Retrieve and query journal entries.
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 the only supported column.
SELECT * FROM JournalEntries WHERE BatchId = 123
Columns
| Name | Type | References | Description |
| JournalEntryId [KEY] | Integer | The journal entry identifier. | |
| BatchId | Integer | The batch identifier. | |
| AccountNumber | String | The journal entry account number. | |
| TypeCode | String | The journal entry transaction type (debit or credit). | |
| Journal | String | The full name of the journal. | |
| LineNumber | Integer | The journal entry line number. | |
| Reference | String | The journal entry reference. | |
| PostDate | Datetime | The journal entry post date, in ISO 8601 format: 2016-03-14. | |
| Amount | Double | The journal entry amount. | |
| Notes | String | The journal entry notes. | |
| Encumbrance | String | The journal entry encumbrance type. | |
| Distributions | String | The journal entry distributions. | |
| CustomFields | String | Custom field : The list of custom fields supported as distict columns. |