CData JDBC Driver for Reckon 2019 - Online Help
Questions / Feedback?


CData JDBC Driver for Reckon 2019 - Build 19.0.7354

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.


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


Customer name this transaction is recorded under.
CustomerId String


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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0