TransactionDistributions
Returns a list of transactions matching the search criteria
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.
- BatchId, AccountNumber , UiProjectId , TypeCode , Encumbrance, Journal, and PostStatus support the '=' operator. A blank search is not supported.
- PostDate supports the following operators : <,<=,=,>=,>.
- DateModified supports the following operators : >,>=.
SELECT * FROM TransactionDistributions WHERE BatchId = 123 AND PostDate < '2010-01-01 10:10:10' SELECT * FROM TransactionDistributions WHERE AccountNumber = 'abc' AND Journal = 'def' AND PostDate <= '2010-01-01 10:10:10' SELECT * FROM TransactionDistributions WHERE UiProjectId = 'abc' AND PostStatus = 'def' AND PostDate = '2010-01-01 10:10:10' SELECT * FROM TransactionDistributions WHERE TypeCode = 'abc' AND DateModified > '2010-01-01 08:10:10' AND PostDate >= '2010-01-01 10:10:10' SELECT * FROM TransactionDistributions WHERE Encumbrance = 'abc' AND PostDate > '2010-01-01 10:10:10'
Columns
| Name | Type | References | Description |
| DistributionId [KEY] | Integer | The distribution identifier. | |
| TransactionId [KEY] | Integer | The transaction identifier. | |
| TransactionAmount | Double | The transaction amount. | |
| BatchId | Integer |
JournalEntryBatches.BatchId | The batch identifier |
| DistributionAmount | Double | The distribution amount. | |
| AccountNumber | String |
Accounts.AccountNumber | The account number. |
| AccountClass | String | The account class. | |
| UiProjectId | String | The project user-visible identifier. | |
| PostDate | Datetime | The transaction post date. | |
| TypeCode | String | The transaction type (debit or credit).
The allowed values are Debit, Credit. | |
| Reference | String | The transaction reference. | |
| Encumbrance | String | The transaction encumbrance type. | |
| Journal | String | The full name of the journal. | |
| TransactionCodeValues | String | The distribution transaction codes. | |
| DateAdded | Datetime | The created date of the transaction distribution. | |
| AddedBy | String | The creator of the transaction distribution. | |
| DateModified | Datetime | The modified date of the transaction distribution. | |
| ModifiedBy | String | The modifier of the transaction distribution. | |
| PostStatus | String | The post status of the transaction distribution. |