StatementChargeLinkedTransactions
Query Reckon Statement Charge Linked Transactions.
Table Specific Information
Linked transactions are transactions that have been associated with the StatementCharge specified by the StatementChargeId column.
Columns
Name | Type | References | Description |
ID [KEY] | String | The unique identifier in the format StatementChargeId|TransactionLineId. | |
StatementChargeId | String | The item identifier. | |
ReferenceNumber | String | Transaction reference number. | |
TxnNumber | Integer | The transaction number. An identifying number for the transaction, different from the Reckon-generated Id. | |
CustomerName | String |
Customers.FullName | Customer name this transaction is recorded under. |
CustomerId | String |
Customers.ID | Customer Id this transaction is recorded under. |
Date | Date | Transaction date. | |
TransactionId | String | The Id of the linked transaction. | |
TransactionAmount | Double | The amount of the linked transaction. | |
TransactionDate | Date | The date of the linked transaction. | |
TransactionReferenceNumber | String | The reference number of the linked transaction. | |
TransactionType | String | The type of linked transaction. | |
TransactionLinkType | String | The link type between the statement charge and linked transaction. | |
TimeModified | Datetime | When the statement charge was last modified. | |
TimeCreated | Datetime | When the statement charge was created. |